OraFAQ Forum: Forms » FRM-40202: Field must be entered.

Home » Developer & Programmer » Forms » FRM-40202: Field must be entered. (oracle 10g R2)

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

FRM-40202: Field must be entered. [message #579558]

Wed, 13 March 2013 04:40

7anona
Messages: 72
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

Report message to a moderator

Re: FRM-40202: Field must be entered. [message #579577 is a reply to message #579558]

Wed, 13 March 2013 07:19

mughals_king
Messages: 392
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

Report message to a moderator

Re: FRM-40202: Field must be entered. [message #579834 is a reply to message #579577]

Fri, 15 March 2013 22:38

7anona
Messages: 72
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 ?

Report message to a moderator

Re: FRM-40202: Field must be entered. [message #579997 is a reply to message #579834]

Mon, 18 March 2013 16:02

mughals_king
Messages: 392
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:	populate the list dynamically
Next Topic:	Master / Detail Relation question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 06:14:38 CST 2025