>>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
>
>You dont need to requery twice. In fact it doesnt work because views dont bring over the deleted status of a record when the view is executed. IOW if you have set DELETED OFF and requery the view, you will see both SSNs but you wont know which was deleted!
>
>You can put !DELETED() in the filter of the index expression. If you do this you should also have an index tag on DELETED() - this will help Rushmore Optimization.

Yes I was indeed overcomplicating my life, but that doesn't answer the important question: How can I RECALL a DELETED record using the bIZOBJ?