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.
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;