OraFAQ Forum: Forms » how to skip a trigger ?

Home » Developer & Programmer » Forms » how to skip a trigger ? (10 g R2)

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

how to skip a trigger ? [message #579210]

Sat, 09 March 2013 00:54

7anona
Messages: 72
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

Report message to a moderator

Re: how to skip a trigger ? [message #579234 is a reply to message #579210]

Sat, 09 March 2013 13:47

Littlefoot
Messages: 21807
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.

Report message to a moderator

Re: how to skip a trigger ? [message #579271 is a reply to message #579234]

Mon, 11 March 2013 00:31

7anona
Messages: 72
Registered: February 2012

Member

Thank you Littlefoot, I used a flag as a global variable
and it worked thanks again

Report message to a moderator

Previous Topic:	Fingerprint
Next Topic:	Performing validation based on unique values in a form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 16:18:58 CDT 2024