I have one table Named DUPLICATA with several columns (ex 30 columns) and i Have a Trigger in this table (Update and Delete) that Update a Table LOGDUPLICATA in other words each Update ou delete in DUPLICATA i Insert the old record in LOGDUPLICATA everything works fine.
But i have 7 Diferents Programs one Update 5 columns, othes 7 columns, another one 1 column, etc
in each Program the Triggers is FIRED.
the question?
Is there a way to do something like this?
SET TRIGGERS ON SET TRIGGERS OFF
BECAUSE IN some Programa i would not like to FIRED the trigger.
tks
C. Lages full time NetCobol x SQL x Cristal Reports
In this case none of my programs updating my Table DUPLICATA , will fire the Trigger. I want that in some programs the TRIGGERS is Fired and only one Dont.
in Create Trigger HELP on BOL there are this option
IF UPDATE ( column )
the trigger will be fired only if desired Column is Updated
i am looking for IF UPDATE ( column ) DONT FIRE THE TRIGGER
This is because the table has too many columns than is easier use the negative.
IF UPDATE ( columnX ) do nothing otherwise i have to write
IF UPDATE ( columna , Columnb, columnc .....column80 etc )
enable/Disable Triggers
Posted - 04/05/2005 : 15:31:57
