Re: adoquery/stored procedure - original and modified values?

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

P.S.Bell wrote:
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

.