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

>>> 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?
> I was thinking that myself, but Patrick said that it was the "old" value which was being changed to the "new" value.

Right. Perhaps NEW is changed to OLD?

> Another trigger (a BEFORE UPDATE trigger), in a single update operation/chain, can only change the "new" value, nothing should be able to change the "old" value.

With regards,
Thomas Steinmaurer

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