Problem with forms and triggers Forms 6i (Validating individual items)
I am using Oracle Forms 6i
My issue is that I have created a form that has a record on it that has six number field and 6 check boxes 1 that relates to each field. I need to be able to know if one or more of the number fields are changed or touched that is, typing 5 over 5 still counts. If field A for example is changed from 5 to 7 I need to set the flag a to true but not the other flags. Is there a better trigger to use then when validate item as this code just set all flags to true rather than only the one I am interested in. What I am needing is item specific actions not record specific actions.
IF i_event = 'WHEN-VALIDATE-ITEM' THEN
IF NAME_IN('SYSTEM.trigger_item') = 'MINS.RATE_A_SCORE'
THEN
msg_alert('I am in rate a score','I',FALSE);
COPY('Y', 'mins.RATE_A_FLAG'); END IF ;
IF NAME_IN('SYSTEM.trigger_item') = 'MINS.RATE_B_SCORE' THEN COPY('Y', 'mins.RATE_B_FLAG'); END IF ;
IF NAME_IN('SYSTEM.trigger_item') = 'MINS.RATE_C_SCORE' THEN COPY('Y', 'mins.RATE_C_FLAG'); END IF ;
IF NAME_IN('SYSTEM.trigger_item') = 'MINS.RATE_D_SCORE' THEN COPY('Y', 'mins.RATE_D_FLAG'); END IF ;
IF NAME_IN('SYSTEM.trigger_item') = 'MINS.RATE_E_SCORE' THEN COPY('Y', 'mins.RATE_E_FLAG'); END IF ;
IF NAME_IN('SYSTEM.trigger_item') = 'MINS.RATE_SP_SCORE' THEN COPY('Y', 'mins.RATE_SP_FLAG'); END IF ;
END IF ;