Thanks Nige!

How can I retrieve the current user, and therefore skip the trigger ?

I guess something like:

if Current_user <> 'XXX' then |
BEGIN
TRIGGER
END

Fabian

----- Original Message -----
From: "Nigel Weeks" <nweeks@...>
To: <firebird-support@yahoogroups.com>
Sent: Friday, December 08, 2006 1:00 PM
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]
>
>