Home » Developer & Programmer » Forms » FRM-40202: Field must be entered. (oracle 10g R2)
FRM-40202: Field must be entered. [message #579558] Wed, 13 March 2013 04:40 Go to next message
7anona
Messages: 57
Registered: February 2012
Member
Hello to all,,
I'm having some columns in my form with required_property
set to yes. When I'm trying to query FRM-40202 appears. I've tryed
some solutions posted in the forum but the problem is not solved
please assist, thanks
Re: FRM-40202: Field must be entered. [message #579577 is a reply to message #579558] Wed, 13 March 2013 07:19 Go to previous messageGo to next message
mughals_king
Messages: 390
Registered: January 2012
Location: pakistan
Senior Member
Message

FRM-40202: Field must be entered.

Cause of Error

This behavior occurs when you try to move to another record, or to another field in the current record, but there is no data in a field that requires data input in the current record (either because you have not entered data in the field or because you have deleted data from that field).
Solution Summary

Enter the required data in the field.
Solution Details


Best regards
Mughal

Re: FRM-40202: Field must be entered. [message #579834 is a reply to message #579577] Fri, 15 March 2013 22:38 Go to previous messageGo to next message
7anona
Messages: 57
Registered: February 2012
Member
this message occurs when I press the enter-query button, not when filling data
How can I remove this message and allow users to enter their
query ?
Re: FRM-40202: Field must be entered. [message #579997 is a reply to message #579834] Mon, 18 March 2013 16:02 Go to previous message
mughals_king
Messages: 390
Registered: January 2012
Location: pakistan
Senior Member
have u solved your problem
otherwise
please upload your code or .fmb file

or try to do this
---------------Example------------

set block property Query Allowed to Yes
set item property Query Allowed of item_code and item_name to Yes

So if you press F7 then your form is in Enter Query mode.

Regards
Mughal




[Updated on: Mon, 18 March 2013 16:07]

Report message to a moderator

Previous Topic: How to design Hierarchical Tree Menu for calling forms & Reports.
Next Topic: Master / Detail Relation question
Goto Forum:
  


Current Time: Sun Dec 21 07:59:36 CST 2014

Total time taken to generate the page: 0.12088 seconds