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.
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: 21561
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Try with ON-ERROR and/or ON-MESSAGE triggers.
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: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
I'd check the form_status and only issue the commit if it's CHANGED.
Previous Topic: UsterSa
Next Topic: How to send report to thermal printer?
Goto Forum:
  


Current Time: Thu May 28 04:07:25 CDT 2020