Hi,

> 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 2.5.2.26539.

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
http://www.upscene.com/

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