Home » Developer & Programmer » Forms » How to avoid message: FRM-40505
How to avoid message: FRM-40505 [message #663072] Sun, 21 May 2017 12:40 Go to next message
mashhoodnasir
Messages: 26
Registered: May 2017
Junior Member
I am using a trigger: when-button-pressed with following detail:
:SYSTEM.MESSAGE_LEVEL := 25;
COMMIT;
:SYSTEM.MESSAGE_LEVEL := 0;

this trigger work fine when ist entry saved but when we saved 2nd entry following message occur:
FRM-40405 : No changes to apply error.

how to avoid this message.

Report message to a moderator

Re: How to avoid message: FRM-40505 [message #663080 is a reply to message #663072] Mon, 22 May 2017 01:00 Go to previous messageGo to next message
Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Try with ON-ERROR and/or ON-MESSAGE triggers.

Report message to a moderator

Re: How to avoid message: FRM-40505 [message #663082 is a reply to message #663080] Mon, 22 May 2017 02:52 Go to previous message
cookiemonster
Messages: 13975
Registered: September 2008
Location: Rainy Manchester
Senior Member
I'd check the form_status and only issue the commit if it's CHANGED.

Report message to a moderator

Previous Topic: UsterSa
Next Topic: How to send report to thermal printer?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Feb 27 15:41:28 CST 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.