OraFAQ Forum: Forms » Error FRM-40207

Home » Developer & Programmer » Forms » Error FRM-40207

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

Error FRM-40207 [message #329958]

Fri, 27 June 2008 02:30

sweetkhaliq
Messages: 200
Registered: April 2006

Senior Member

I am using developer 6i and oracle 9i database.
I have a voucher form in which i have a date filed. I have facing a problem that when i in date field and press enter then i gives error frm-40207 Must be in range...to 27-jun-08 and cursor remain in the same field. I have not define any range. and i have check trigger on this field that are ok and have no concern with this error.
Please tell me what is the problem.

I will be very thankfull to you.

Report message to a moderator

Re: Error FRM-40207 [message #329971 is a reply to message #329958]

Fri, 27 June 2008 03:05

jramya
Messages: 42
Registered: April 2008

Member

Have you set up the DataType and Format Mask for that field?
I encountered the same and on correcting those fixed.
Have a try!

Report message to a moderator

Re: Error FRM-40207 [message #329983 is a reply to message #329958]

Fri, 27 June 2008 03:30

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Open this item's Property Palette. Go to "Data" node and check Lowest and HIghest Allowed Value properties.

Such a message ("Must be in range ...") is a result of a set highest Allowed Value; it seems that it is set to SYSDATE (i.e. $$date$$ in Forms).

Report message to a moderator

Re: Error FRM-40207 [message #330000 is a reply to message #329958]

Fri, 27 June 2008 04:47

sweetkhaliq
Messages: 200
Registered: April 2006

Senior Member

Thanks Littlefoot
You have guessed the exact problem. I have eliminate the highest allowed value know it work well.
Thanks

Report message to a moderator

Previous Topic:	Making a display item editable at time of insert and uneditable after an insert.
Next Topic:	Jacob.jar/WEBUTIL ERROR-Urgent Help Needed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 06:26:48 CST 2025