Home » Developer & Programmer » Forms » How to avoid FRM-40401 message? (Windows XP, Oracle Developer Suit 10g)
How to avoid FRM-40401 message? [message #354143] Thu, 16 October 2008 09:50 Go to next message
ranjith_amrita
Messages: 44
Registered: August 2008
Location: Coimbatore
Member
Hi,

While I am inserting and updating the values in the oracle database its showing a message 'FRM-40401 - No changes to save.' I don't want this message to be shown. How can I do that? Please help me.

Ranjith.
Re: How to avoid FRM-40401 message? [message #354192 is a reply to message #354143] Thu, 16 October 2008 22:36 Go to previous messageGo to next message
boyet-x
Messages: 23
Registered: August 2006
Junior Member
I am thinking maybe you can suppress the error in On-Error trigger.
Maybe something to check if ERROR_CODE = 40401, then do nothing.
Not sure tho if it works Wink
icon7.gif  Re: How to avoid FRM-40401 message? [message #354401 is a reply to message #354192] Sat, 18 October 2008 07:31 Go to previous messageGo to next message
ranjith_amrita
Messages: 44
Registered: August 2008
Location: Coimbatore
Member
Hi...

Thanks for your reply. I'll try this and let you know the result. thanks once again
Re: How to avoid FRM-40401 message? [message #354566 is a reply to message #354143] Mon, 20 October 2008 05:55 Go to previous messageGo to next message
cookiemonster
Messages: 12321
Registered: September 2008
Location: Rainy Manchester
Senior Member
You could also change the system.message_level to supress that message.
Have a look in form builder help for details.
Re: How to avoid FRM-40401 message? [message #432069 is a reply to message #354143] Fri, 20 November 2009 19:12 Go to previous messageGo to next message
waleedobeidat
Messages: 1
Registered: November 2009
Junior Member
hi,

the easiest way is to use standard.commit rather than commit

Re: How to avoid FRM-40401 message? [message #538578 is a reply to message #432069] Sat, 07 January 2012 05:54 Go to previous message
bhaskar@abc
Messages: 2
Registered: January 2012
Location: Bangalore
Junior Member
Thanks alot. standard.commit is working
Previous Topic: HOW GENERATE ITEM CODE CONCATENATE WITH MAIN ITEM AND SUB ITEM (merged 2)
Next Topic: Cant execute query
Goto Forum:
  


Current Time: Fri Sep 30 15:53:14 CDT 2016

Total time taken to generate the page: 0.32450 seconds