| Subject | Re: [firebird-support] Re: After update trigger: the same values for new.somefiled and old.somefield |
|---|---|
| Author | Helen Borrie |
| Post date | 2016-08-29T08:37:55Z |
> 29.08.2016 10:24, patrick_marten@... [firebird-support] wrote:And they fire BEFORE the **transaction** is committed (or rolled
>> 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.
back).
Commit - all changes take effect and become visible to other
transactions
Rollback - no changes take effect at all.
HB