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