Re: Database update module???

2004-09-09 Thread Tim Bunce
On Wed, Sep 08, 2004 at 07:47:34PM -0500, NIPP, SCOTT V (SBCSI) wrote: > 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

RE: Database update module???

2004-09-09 Thread NIPP, SCOTT V (SBCSI)
Sent: Thursday, September 09, 2004 12:51 PM To: [EMAIL PROTECTED] Subject: Re: Database update module??? What database are you using. A database that supports triggers will handle this quite nicely. >>>NIPP, SCOTT V (SBCSI) <[EMAIL PROTECTED]> 09/08 11:47 am >>

Re: Database update module???

2004-09-09 Thread Ian Harisay
What database are you using. A database that supports triggers will handle this quite nicely. >>>NIPP, SCOTT V (SBCSI) <[EMAIL PROTECTED]> 09/08 11:47 am >>> I have created a database that has a table for the active data, and a table that basically captures the changes to

RE: Database update module???

2004-09-09 Thread Dan Hopkins
> -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

Database update module???

2004-09-08 Thread NIPP, SCOTT V \(SBCSI\)
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