Subject Re: [firebird-support] After update trigger: the same values for new.somefiled and old.somefield
Author Thomas Steinmaurer

> shouldn't the values of new.somefield and old.somefield be different in
> an after update trigger, when the value of that field has definitely
> changed?
> For some reason they both have the new value and I can't figure out why.
> If I didn't misread all the articles, I've found, completely, then they
> should be different, shouldn't they?
> I'm using Firebird

Any chance that another trigger is changing the value?

You might use the Trace API to find out what's going on ...

With regards,
Thomas Steinmaurer

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.