brokeMyLegBiking
asked on
find out if a field has changed in a datatable
How can I find out if a field has changed in a data table?
I am trying to create an audit record of any changes that are made to the data in a table which is bound to textbox controls on a form. Before I insert a new audit record, I need to figure out which values are different from the underlying data.
I am trying to create an audit record of any changes that are made to the data in a table which is bound to textbox controls on a form. Before I insert a new audit record, I need to figure out which values are different from the underlying data.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
MsFox, that sounds right, let me try that.
dim i, j as integer
i=0
while i < then dataset1.tables(0).rows.co
j=0
While j < dataset1.tables(0).colums.
if dataset1.tables(0).rows(i)
'no diffrences so do notin
else
'diffrence here so do audit
j=j+1
end while
i=i+1
end while