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.
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.
C. Lages full time NetCobol x SQL x Cristal Reports