> -----Original Message----- > From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED] > Sent: 09 September 2004 01:48 > To: [EMAIL PROTECTED] > Subject: Database update module??? > > > I have created a database that has a table for the active data, > and a table that basically captures the changes to that table. The > second table has all of the same fields as the first with one > extra and > that being to capture a date of the change. I know that I can write a > piece of code to compare the incoming data to the existing > data and then > update accordingly. This seems like it would be an extremely common > thing to do though. I was wondering if someone might know of a module > to do this? Thanks in advance.
Scott, You don't mention which database you're using - but your first port of call would be to investigate any trigger implementations your db supports. This would ideally be done using a 'before update' trigger in the database rather than in application code -- Dan Hopkins
