Subject RE: [firebird-support] After update trigger: the same values for new.somefiled and old.somefield
Author Leyne, 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.

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.