RE: MIDRANGE-L digest, Vol 1 #2641 - 14 msgs

The more elegant solution would be not to have to worry about deleted records 
in the first place.  I could think of a simple change that should solve this 
problem.

Create a duplicate of your file without data.  So it would have the same record 
structure, but no data.  Now write a small program that reads from memory, 
dumps into the file buffer and writes the record.

Now, trigger this program on the file for *DELETE *BEFORE.

When this program gets triggered, it would simply write the record being 
deleted from your production file into your copy file.

Now, you want to find the records that were deleted, just query your copy file.

Regards,

Jim Langston

From: "Steve Landess" <steve_landess@hotmail.com>
<SNIP>

I would like to build a more elegant solution so that I don't necessarily have 
to write a new program every time I want to retrieve the deleted records from a 
file.