OraFAQ Forum: Forms » frm 40202 field must be entered error oracle

Home » Developer & Programmer » Forms » frm 40202 field must be entered error oracle (Forms [32 Bit] Version 10.1.2.2.0 (Production))

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

frm 40202 field must be entered error oracle [message #652643]

Wed, 15 June 2016 08:02

Mraouf
Messages: 14
Registered: June 2016
Location: Egypt

Junior Member

i got > frm 40202 field must be entered error oracle

i have been made initial value for some items in When new from instance so i couldn't make ctr f11 or f11 to query data

Report message to a moderator

Re: frm 40202 field must be entered error oracle [message #652644 is a reply to message #652643]

Wed, 15 June 2016 08:13

adfnewbie
Messages: 54
Registered: January 2016

Member

Are you trying to save the data/changes? If you have made the field mandatory then you have to have a value assigned to it.

Report message to a moderator

Re: frm 40202 field must be entered error oracle [message #652649 is a reply to message #652644]

Wed, 15 June 2016 09:04

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

I wouldn't set values in WNFI. Doing that means that oracle thinks you're trying to insert a new record and won't let you query until you've saved the record or cleared it. Set default values in when-validate-record or pre-insert.

Report message to a moderator

Re: frm 40202 field must be entered error oracle [message #652651 is a reply to message #652649]

Wed, 15 June 2016 09:15

adfnewbie
Messages: 54
Registered: January 2016

Member

Cookiemonster,

Is there a way where I can assign value to a field and Oracle does not take it as a new record?

Report message to a moderator

Re: frm 40202 field must be entered error oracle [message #652654 is a reply to message #652651]

Wed, 15 June 2016 10:37

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Not really no. If you use the initial value property this doesn't happen but any attempt to assign a value from a trigger will cause it.

Report message to a moderator

Re: frm 40202 field must be entered error oracle [message #652655 is a reply to message #652649]

Wed, 15 June 2016 11:01

Mraouf
Messages: 14
Registered: June 2016
Location: Egypt

Junior Member

thanks but how i can set the default value is the same syntax as initial value or not

Report message to a moderator

Re: frm 40202 field must be entered error oracle [message #652682 is a reply to message #652655]

Thu, 16 June 2016 03:23

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

initial value property is a property in the items property palette. No syntax involved you just enter the value next to the property.

Report message to a moderator

Previous Topic:	Migration from 6i to 11g - font problems
Next Topic:	How to control editing at particular record in Detail Block

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 04:45:41 CST 2025