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.
