>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.
Mark McCasland
Midlothian, TX USA