That's 'Deactivate', not 'inactive' the triggers....sorry.

`alter trigger [triggername] inactive`

N.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]On Behalf Of Nigel Weeks
Sent: Friday, 8 December 2006 1:00 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] How can I run an "Update Table" with no
triggers?


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.

Nige.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]On Behalf Of fabianchocron
Sent: Friday, 8 December 2006 12:52 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] How can I run an "Update Table" with no
triggers?

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]






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