October 4th, 2004, 01:51 AM
|
|
Permanently Banned
|
|
Join Date: Sep 2003
Location: Iceland
Posts: 47
Time spent in forums: 6 h 53 m 21 sec
Warnings Level: 10
Number of bans: 1
Reputation Power: 0
|
|
Trigger Calling Extended Stored Procedure
Hello,
I've installed a "For Update" trigger for some table that calls a extended stored procedure (ESP). In some cases, the ESP needs to modify the same table, maybe causing a recursive call of the trigger.
Is there a way to "disable" the trigger inside the code just before the operation that updates the table and "re-enable" it just after?  I know I can disable recursive triggering at database level, but I'm developing a database add-on so I don't want to interfere with the existing triggers behavior (if any) for the rest of the tables.
10x.
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
