Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateContext variables → NEW
Firebird Home Firebird Home Prev: INSERTINGFirebird Documentation IndexUp: Context variablesNext: 'NOW'

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

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.

Prev: INSERTINGFirebird Documentation IndexUp: Context variablesNext: 'NOW'
Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateContext variables → NEW