Paul Schmidt wrote:

> Deletes
>
> You can't delete a delete, just flag it as deleted, using a status field,
> otherwise you can't transmit the delete to HO or anywhere else. The
> advantage of this is that you can add an un-delete feature, by flipping the
> flag back to clear. Then write a program that goes through and deletes the
> records marked as delete, which you might run every month, or even annually,
> the most important thing is that you run it AFTER a complete database backup.

I have a table called DELETED_RECORDS which contains just primary key
values of records that are deleteted.

Just my $0.02

Milan.