This content has been marked as final. Show 1 reply
MAHA REDDY wrote:Hi Maha
I have developed custom form in this form 5 fields is there in one block if i enter the all fields some any values then press the save option it will be saved.
when one field put null (mean does't enter the value)then press the save option it's not saved.
If you think save option in the entire form for all the fields, use Pre-Commit or ON-COMMIT at form level.
Hope this works..
/* sample code for the above trigger */ IF :COLUMN1 IS NOT NULL AND :COLUMN2 IS NOT NULL THEN COMMIT_FORM; ELSE MESSAGE(' NO '); MESSAGE(' NO '); RAISE FORM_TRIGGER_FAILURE; END IF;