Keep track as data changes

[vnarod]

I need to store an old and new record in audit table (Sybase)every time data changes. All changes are done using ExecuteNonQuery method passing SQL statement.

So if I need to "DELETE TABLE1 WHERE Value='a'" I have to do

"SELECT * FROM TABLE1 WHERE Value='a'" first and write result to an audit table. Is there an easier way to solve this problem?

[Nerseus]

The short answer is no.

 

You could write a trigger for each table and have it write to the audit log - that's fairly common.

 

I've done what you mention (SELECT, DELETE, SELECT again) to handle auditing in the past. It's not bad, but it just "feels" wrong somehow...

 

-Nerseus