| Firebird Documentation Index → Firebird 2.5 Language Ref. Update → Context variables → NEW |
|
|
|
Available in: PSQL, triggers only
Changed in: 1.5, 2.0
Description: NEW 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.
Type: Data row
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.
|
| Firebird Documentation Index → Firebird 2.5 Language Ref. Update → Context variables → NEW |