description: SFID: 1190233#⁠
Submitted By: konstbel

The problem is to track changes/deletes in database.
If we need to keep old values of some record, we have to
copy them in some log table with the same structure or
construct some XML or INI-like structure inside
BEFORE * trigger and put it into the BLOB of log table.
But if we change table structure, we'll have to also
change log table and triggers.
I think it is good to make this function internal: return the
whole record in any reasonable format, ready to put into
varchar or BLOB.
The syntax may be
GET_AS_RECORD(<fields_list>) or
GET_AS_RECORD(OLD.*)

=>

SFID: 1190233#⁠
Submitted By: konstbel

The problem is to track changes/deletes in database.
If we need to keep old values of some record, we have to
copy them in some log table with the same structure or
construct some XML or INI-like structure inside
BEFORE * trigger and put it into the BLOB of log table.
But if we change table structure, we'll have to also
change log table and triggers.
I think it is good to make this function internal: return the
whole record in any reasonable format, ready to put into
varchar or BLOB.
The syntax may be
GET_AS_RECORD(<fields_list>) or
GET_AS_RECORD(OLD.*)

Workflow: jira [ 10685 ] => Firebird [ 15062 ]