|
|
|
|
Re: forms [message #628421 is a reply to message #628403] |
Tue, 25 November 2014 03:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
If you exit form without changing anything then you wont get a message anyway. If you think you haven't changed anything and are getting a message anyway then that'll be because there is code in the form making changes. In which case the solution is to find that code and fix, not mask the problem with exit_form(no_validate).
|
|
|
|
Re: forms [message #628437 is a reply to message #628429] |
Tue, 25 November 2014 04:43 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
It can be any code that changes a datablock item and it can be in almost any trigger (other than ones that only fire when you have already modified data - the validate triggers and pre-insert/update/delete). If you're struggling to work out which bit of code is the culprit then you will probably need to add messages to the triggers that display :system.block_status or :system.form_status and see at what point the status becomes CHANGED.
|
|
|
|
Re: forms [message #628452 is a reply to message #628450] |
Tue, 25 November 2014 07:00 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
What alert message are you trying to suppress?
Because generally speaking you shouldn't try to suppress alert messages, they're there for a reason. If necessary you should be avoiding getting into the situation that causes the alert in the first place.
|
|
|
|
|
|
Re: forms [message #628629 is a reply to message #628542] |
Wed, 26 November 2014 08:30 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
"did not work" is not a valid Oracle error message. Where is this trigger? What is this trigger? Just creating a user named trigger will do nothing unless you call it.
[Updated on: Wed, 26 November 2014 08:30] Report message to a moderator
|
|
|