I am new with Oracle Forms.
I am developing an application using Oracle 10g express and forms 6i.
Can somebody please guide me regarding code under SAVE button(I have placed some push buttons on form for add_new, Save, Reset ect).
I am trying to handle DUPLICATE_RECORDS AND NULL_VALUES through this code which is in ON_ERROR form trigger
if dbms_error_code in (-1400, -1407) then
elsIF dbms_error_code='-00001' then
and code under SAVE button is
but even form is prompting for duplicate value or null value, Alert_save is showing as record has been saved.
My question is how I can be sure that record has been saved actually?????
I have tried to check :SYSTEM.FORM_STATUS and it return CHANGED .
is there any approach I should use, any sample piece of code will be much appreciated.
Well, looking at the Forms Help System, (FORM_SUCCESS built-in) they give an example of how to test if the commit was successful.
IF Form_Success THEN Commit; IF :System.Form_Status <> 'QUERY' THEN Message('Error prevented Commit'); RAISE Form_Trigger_Failure; END IF; END IF;