Firebird Documentation IndexFirebird 2.5 Language Ref. UpdateContext variables → DELETING
Firebird Home Firebird Home Prev: CURRENT_USERFirebird Documentation IndexUp: Context variablesNext: GDSCODE

DELETING

Tip

Find a more recent version at Firebird 5.0 Language Reference: DELETING

Available in: PSQL

Added in: 1.5

Description: Available in triggers only, DELETING indicates if the trigger fired because of a DELETE operation. Intended for use in multi-action triggers.

Type: boolean

Example: 

if (deleting) then
begin
  insert into Removed_Cars (id, make, model, removed)
    values (old.id, old.make, old.model, current_timestamp);
end
Prev: CURRENT_USERFirebird Documentation IndexUp: Context variablesNext: GDSCODE
Firebird Documentation IndexFirebird 2.5 Language Ref. UpdateContext variables → DELETING