Adam

You are right but the example was from README.context_variables
(copy-paste). Sorry.



Best regards,

Paul



From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Adam
Sent: Friday, August 03, 2007 8:01 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Help with triggers...

>
> Ex: IF (INSERTING OR DELETING) THEN NEW.ID = GEN_ID(G_GENERATOR_1, 1);
>

Paul,

I think she wants to know how to know whether a particular column was
impacted by an update, not whether a trigger is being fired because of
an insert, update or delete.

(By the way, you can't assign a value to NEW.<anything> inside a
delete trigger)

Adam





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