FRM-40202 (Field Must be entered) [message #85017] |
Sun, 23 May 2004 21:06 |
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 |
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
|
|
|
|