OraFAQ Forum: Forms » How to avoid FRM-40401 message?

Home » Developer & Programmer » Forms » How to avoid FRM-40401 message? (Windows XP, Oracle Developer Suit 10g)

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

How to avoid FRM-40401 message? [message #354143]

Thu, 16 October 2008 09:50

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.

Report message to a moderator

Re: How to avoid FRM-40401 message? [message #354192 is a reply to message #354143]

Thu, 16 October 2008 22:36

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

Report message to a moderator

Re: How to avoid FRM-40401 message? [message #354401 is a reply to message #354192]

Sat, 18 October 2008 07:31

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

Report message to a moderator

Re: How to avoid FRM-40401 message? [message #354566 is a reply to message #354143]

Mon, 20 October 2008 05:55

cookiemonster
Messages: 13973
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.

Report message to a moderator

Re: How to avoid FRM-40401 message? [message #432069 is a reply to message #354143]

Fri, 20 November 2009 19:12

waleedobeidat
Messages: 1
Registered: November 2009

Junior Member

hi,

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

Report message to a moderator

Re: How to avoid FRM-40401 message? [message #538578 is a reply to message #432069]

Sat, 07 January 2012 05:54

bhaskar@abc
Messages: 2
Registered: January 2012
Location: Bangalore

Junior Member

Thanks alot. standard.commit is working

Report message to a moderator

Previous Topic:	HOW GENERATE ITEM CODE CONCATENATE WITH MAIN ITEM AND SUB ITEM (merged 2)
Next Topic:	Cant execute query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 03 20:59:39 CST 2025