9.11. NEW
Available inPSQL, triggers only
TypeData row
DescriptionNEW
contains the new version of a database record that has just been inserted or updated.
Starting with Firebird 2.0 it is read-only in AFTER
triggers.
ⓘ
Note
In multi-action triggers — introduced in Firebird 1.5 — NEW
is always available.
But if the trigger is fired by a DELETE
, there will be no new version of the record.
In that situation, reading from NEW
will always return NULL
;
writing to it will cause a runtime exception.