Home » Developer & Programmer » Forms » FRM-40202 (Field Must be entered)
FRM-40202 (Field Must be entered) [message #85017] Sun, 23 May 2004 21:06 Go to next message
pinky
Messages: 26
Registered: May 2002
Junior Member
i have created a silplest form
of emp table (schema=scott)
when i run the form and using standarad Menu bar
records displayed in the fields
but when i put the code
EXECUTE_QUERY; in the WHEN_BUTTON_PRESSED event of
a button
it results
FRM-40202 (Field Must be entered)
i m a newbabie at FORMS 6i

plz tell me how to capture that
exceptoin and solve the problem

Regards
Pinky
Re: FRM-40202 (Field Must be entered) [message #85022 is a reply to message #85017] Mon, 24 May 2004 02:19 Go to previous messageGo to next message
Anupam
Messages: 62
Registered: July 2001
Member
there are two option to solve this problem
first
assign the button into new control_block (block which is not assoiated with database) and write this code

go_item('empno');
execute_query;

second
turn off the mouse navigate property of button.
and write this code
execute_query;
and u remain place on the same block;

hope it ll help u
all the best
Re: FRM-40202 (Field Must be entered) [message #85037 is a reply to message #85022] Mon, 24 May 2004 21:16 Go to previous message
pinky
Messages: 26
Registered: May 2002
Junior Member
Thanks a lot
friend for giving me Hint
hope u will help me
in future 2
urs friend Pinky
Previous Topic: Forms - Call form Related question
Next Topic: How can I execute a sale invoice report throun form builder command button
Goto Forum:
  


Current Time: Wed May 01 08:57:31 CDT 2024