You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.*)
The text was updated successfully, but these errors were encountered:
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.*)
Submitted by: konstbel (konstbel)
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.*)
The text was updated successfully, but these errors were encountered: