> I'd like ideas / recommendations on implementing and auditing to track delta > changes to tables.
Here's one possibility for auditing. http://www.sqlite.org/cvstrac/wiki?p=UndoRedo Another possibility is to have audit tables are identical copies of the tables being tracked, except for some tracking fields, and implement a trigger that, after an update happens to a row, it creates a new row in the audit table and copies all the existing columns to it, along with values that show the action, date/time of the change, user, application, and any other information that might be relevant. Brad _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
