On Tue, 7 Oct 2003 16:48:55 -0400, Jim wrote
> Hi,
>
> I need to be able to 'delete' records from table(s) but still
> maintain their information for an audit trail.
>
> I'd rather not have a field for a deleted flag and have to condition
> all the queries on the table on the state of this flag
In the last episode (Oct 07), Jim said:
> I need to be able to 'delete' records from table(s) but still
> maintain their information for an audit trail.
>
> I'd rather not have a field for a deleted flag and have to condition
> all the queries on the table on the state of this flag.
>
> Is it pos
Hi,
I need to be able to 'delete' records from table(s) but still maintain their
information
for an audit trail.
I'd rather not have a field for a deleted flag and have to condition all the
queries on the
table on the state of this flag.
Is it possible to move a record from one table to another