Issue Details (XML | Word | Printable)

Key: CORE-661
Type: New Feature New Feature
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: konstbel
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Get a whole record as a single object

Created: 26/Apr/05 12:00 AM   Updated: 03/Jul/07 11:08 AM
Component/s: UDF
Affects Version/s: None
Fix Version/s: None

SF_ID: 1190233


 Description  « Hide
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.*)

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
ramengo added a comment - 03/Jul/07 11:08 AM
This should be achieved with release 2.1 new LIST function