OraFAQ Forum: Forms » To Stop saving when detail record is null

Home » Developer & Programmer » Forms » To Stop saving when detail record is null

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

To Stop saving when detail record is null [message #493152]

Sat, 05 February 2011 11:48

vijaykarthik_4
Messages: 1
Registered: February 2011
Location: INDIA

Junior Member

Hi,

I have master detail block just consider Forms A as a master and Forms B as a Detail,when my cursor is in form A i try to save the record, it is saved Form A and putting Form B data as null, i have to put a validation to stop this activity, i have to inform the user "Provide values for form B text item",

I created a post block trigger in form A

Begin

If (:FORM-B.TEXT1 is null)l or( :FORM-B.TEXT2 is null)
then

Message( 'provide value for FORM-B');
Message( 'provide value for FORM-B');
raise form_trigger_failure;

ELSE
NULL;
END IF
END;

Im Getting error message and navigation got stopped in last item of form A itself,i need to show error message and cursor control should move to first item of form -B please advice me which trigger i have to use for this.i

Thanks and regards
karthik

Report message to a moderator