Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to recall a deleted record using a cursor adapter
Message
 
 
To
23/09/2005 11:13:17
Wen Guo
Financial Models Company
Mississauga, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01052393
Message ID:
01053101
Views:
13
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform