Home » Developer & Programmer » Forms » FRM-40209 : Field must be of form XX,XX,XXX coming several times (Oracle Developer suite, 10g, Windows XP)
FRM-40209 : Field must be of form XX,XX,XXX coming several times [message #567605] Wed, 03 October 2012 08:11 Go to next message
rahulraj777
Messages: 4
Registered: October 2012
Location: Bangalore
Junior Member

I have a form which has a Number field. I set it's Format Mask property to 9,99,99,99,99,999 so that I can format it comma separated and to restrict the user to enter decimal values. If the user enter any format other than this for example any decimal values, it is showing the message FRM-40209:Field must be of the form 9,99,99,99,99,999 which is fine. But when the user enters a decimal value and try to save the form it pop up this message several times.

I tried to catch this error in ON-ERROR trigger and display a message. But this is also pop up several times. I tried to raise form_trigger_failure also. This is also not working. I want this error message to come only once. Please help me. Thanks in advance.
Re: FRM-40209 : Field must be of form XX,XX,XXX coming several times [message #567647 is a reply to message #567605] Wed, 03 October 2012 23:59 Go to previous messageGo to next message
Littlefoot
Messages: 19688
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Run the form in debug mode; it will tell you which triggers fire and, possibly, cause that message to appear many times.
Re: FRM-40209 : Field must be of form XX,XX,XXX coming several times [message #567657 is a reply to message #567647] Thu, 04 October 2012 01:34 Go to previous message
rahulraj777
Messages: 4
Registered: October 2012
Location: Bangalore
Junior Member

Thanks for the reply

ON_ERROR trigger is firing all the times. But I couldn't figure out why it is firing so many times (5 times). I changed only one record value. Even then I am getting this error 5 times.
Previous Topic: image size
Next Topic: list_item selection problem
Goto Forum:
  


Current Time: Wed Oct 22 02:01:08 CDT 2014

Total time taken to generate the page: 0.10249 seconds