A Better Way....

  • Thread starter Thread starter scorpion53061
  • Start date Start date
S

scorpion53061

Don't laugh.....

I didn't know how to do this and I was under a deadline of sorts.

In my Transaction table the boss wanted a record made of when a modification
of a record was done to record in this column the columns that were changed.

I know there is a method in ADO.NET which will tell me what the columns that
changed from the original when it is updated.

What I did for now was assign the values before they were changed ot
variables (there were a lot of variables to account for :( ) and then did
If......Then statements and wrote all the columns that changed to a string
and am writing that for the value.

Could someone post a sample of how to do this properly or point me to an
online tutorial on how to do this the right way?
 
If you want to log data, I would set up a trigger on the table to insert a
record in a log table. This will catch data for all applications that touch
the data, including future applications. This way, even if you application
is not the only one touching the data, all changes are logged. That is what
I would do.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think outside the box!
**********************************************************************
 
Hi Greg.......

Is there a tutorial on line that will teach me how to do this?
I am using an Access databse.
 
Back
Top