Re: [firebird-support] Re: After update trigger: the same values for new.somefiled and old.somefield

2016-08-29 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
> 29.08.2016 10:24, patrick_mar...@yahoo.com [firebird-support] wrote: >> Somehow I've thought that an after update trigger only fires once when all >> the changes >> have been made and comitted. >DML triggers are fired on every change of every record. And they fire BEFORE the

Re: [firebird-support] Re: After update trigger: the same values for new.somefiled and old.somefield

2016-08-29 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
29.08.2016 10:24, patrick_mar...@yahoo.com [firebird-support] wrote: > Somehow I've thought that an after update trigger only fires once when all > the changes > have been made and comitted. DML triggers are fired on every change of every record. -- WBR, SD.

[firebird-support] Re: After update trigger: the same values for new.somefiled and old.somefield

2016-08-29 Thread patrick_mar...@yahoo.com [firebird-support]
Hi guys, thanks for the suggestions and ideas, it helped to track it down. It was not directly another trigger or procedure updating the record in question, but something similar : I had altered an existing trigger. There was an if-block checking a field A for being not null and executing