>>Hi Everybody,
>>
>>We have an existing application which directly accesses VFP data from the user interface. I am trying to separate the data from the interface by using cursoradapters. While doing so, I have come across a problem when I try to recall a deleted record. When a deleted record is retrieved from a cursor adapter, it appears to be a regular record. Deleted() returns FALSE for the record. And there is no way that I can recall it.
>>
>>Any suggestions?
>
>To know the deleted status of a record using a CursorAdapter (i.e., SQL), you have to add a field to your list of selected fields:
>
>Select MyTable.*, deleted() as IsDeleted from MyTable where ...
>
>IsDeleted is just a field alias. You can alias that field to whatever you want.
Thanks a lot, Mark. But how can you recall a deleted record?