Subject RE: [firebird-support] How can I run an "Update Table" with no triggers?
Author Nigel Weeks
You'll have to inactive the triggers before you do the update.

Alternatively, and this will take a bit of preparation, I've created my
triggers with a check at the top, and if a certain user, in my case
'replication' does an operation, the trigger skips it's active section.

Perhaps, fi you're going to do this operation frequently, modify your
triggers to test for a different connected user, and do your operations as
this alternative user to bypass the triggers.


-----Original Message-----
[]On Behalf Of fabianchocron
Sent: Friday, 8 December 2006 12:52 PM
Subject: [firebird-support] How can I run an "Update Table" with no

I wonder if it's possible to run an Update on a Table but without
executing all triggers?
Something like

Update Invoices "With no Triggers"
set Total_Amount = 0
where clientcode = '123'

[Non-text portions of this message have been removed]