adoquery/stored procedure - original and modified values?

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

.

Relevant Pages