Re: Timestamp

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Wed, 10 Nov 1999 15:36:21 -0800
Message-ID: <80cvjc$fmj$1@plo.sierra.com>

If it's crucial to know what records have been deleted, create your own "log" table
and populate with the records from TRIGGERs BEFORE DELETE on each of the respective tables.

Don't forget to add a sysdate value to the insert into the "log"

Alan <paxton_af_at_vdot.state.va.us> wrote in message news:s21ab4h924231_at_corp.supernews.com...
> What Pete said is true, adding a timestamp via a tigger will work for
> inserted or updated records, but it will not indicate records that have
> been deleted. I'm not sure of a good way to handle the deleted records
> using a trigger, but if you find out I would love to know.
>
>
> --
> Posted via CNET Help.com
> http://www.help.com/
Received on Wed Nov 10 1999 - 17:36:21 CST