You can do this with Transact SQL as well (SQL Server). I've setup triggers to monitor specific fields, or you can just store a record for any change on a table.
Email me off-line if you'd like some code examples. > -----Original Message----- > From: Turetsky, Seth [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 11, 2006 10:58 AM > > What database? > On important apps, we have pl/sql triggers that store all of > the changes in log tables > Basically, the table is just the field name, old value, new > value and who changed it > > -----Original Message----- > From: Phill B [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 11, 2006 12:42 PM > > > That would have been a better way of putting it. Yes We want to track > the changes made in the database. We would like to keep it > indefinitely. This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240253 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
