adoquery/stored procedure - original and modified values?

adoquery/stored procedure - original and modified values?

Post by P.S.Bel » Wed, 27 Sep 2006 21:42:42


I have to determine which actual data has changed in modified
ado dataset records (query and stored procedure). I check for
'global' record changes if state=dsEdit. But I need to provide
an audit trail of what has changed. Ideally I would like to
compare original values to modified values for each field by
number and then access the field name if a difference is found.

Pat Bell
 
 
 

adoquery/stored procedure - original and modified values?

Post by Steve Zimm » Wed, 27 Sep 2006 22:34:46

See if this helps...

http://www.yqcomputer.com/

-Steve-

 
 
 

adoquery/stored procedure - original and modified values?

Post by Graha » Thu, 28 Sep 2006 11:46:38

I'm facing this right now, and the best solution I can see is to use
triggers in the database itself. Rather than trying to determine which
fields have changed (especially when some may be multi-megabyte BLOB
fields), I'm going to have shadow tables that have all the fields of the
original tables, plus modification information.

Disk space is cheap.

Graham
 
 
 

adoquery/stored procedure - original and modified values?

Post by P.S.Bel » Tue, 03 Oct 2006 19:34:30

Yes I came to a similar conclusion, although I am using a memory table
(kbmMemTable) that claims to have OrigDataValues method along with a
deltahandler to handle the changes - I'll let you know how I get on. Though
as for the blobs? I don't really have anything comparable though I do have
some data that I am ignoring since it too involved to succinctly log what
the change is.






Pat Bell