I use business objects for all my data handling. I came accross a situation today where I thought there was no existing student record and there was one marked for deletion. This caused the predictable problem when I tried to add a new record with the same SSN.

The only method I can think of for determining whether the record is marked for deletion is to requery() twice, once with SET DELETED ON and again with SET DELETED OFF. This doesn't tell me how to RECALL the record. Am I over complicating my life?

TIA.

TOM