I have a table-buffered table. Before I do an update, I need to scan through all the records and record what's changed. I did this by scanning and checking if newvalue<>oldvalue or if the oldvalue was null, to get the new records.

What I can't figure out is how to get the deleted records. If I do SET DELETED OFF, it gives me all the deleted records in the table, not just those that have been deleted since the last save.

Is there some way to access just those deleted in the buffer, and not deleted in the table?

Thanks,

-Michelle