Home » Developer & Programmer » Forms » how to skip a trigger ? (10 g R2)
how to skip a trigger ? [message #579210] Sat, 09 March 2013 00:54 Go to next message
7anona
Messages: 57
Registered: February 2012
Member
hello every one
in my form I have a button that updates
a table and I have a pre-update trigger
is it possible to skip the pre-update trigger
only when the button is pressed

please assist as soon as possible
thanks
Re: how to skip a trigger ? [message #579234 is a reply to message #579210] Sat, 09 March 2013 13:47 Go to previous messageGo to next message
Littlefoot
Messages: 19823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
One option is: let button set a flag (that could be a form item, a parameter or a global variable - pick one). Check flag's value in PRE-INSERT trigger. If it is set, it means that button set it so - don't do anything. If it is not set, obviously, let it work.

Don't forget to reset the flag at the end of the trigger.
Re: how to skip a trigger ? [message #579271 is a reply to message #579234] Mon, 11 March 2013 00:31 Go to previous message
7anona
Messages: 57
Registered: February 2012
Member
Thank you Littlefoot, I used a flag as a global variable
and it worked thanks again
Previous Topic: Fingerprint
Next Topic: Performing validation based on unique values in a form
Goto Forum:
  


Current Time: Fri Nov 28 12:46:51 CST 2014

Total time taken to generate the page: 0.06846 seconds