Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Vfpoledb and deleted
Message
From
22/05/2003 18:44:55
Len Wooden
Statistical Resources, Inc
Baton Rouge, Louisiana, United States
 
 
General information
Forum:
ASP.NET
Category:
Other
Miscellaneous
Thread ID:
00791960
Message ID:
00791986
Views:
30
>>Using vb.net to access a foxpro 2.6 table via vfpoledb.. and executing a SET DELETED OFF to include records marked for deletion.. then executing a simple select stmt for all records in a table that has a few deleted records.. is it possible to identify the records that were marked for deletion?
>>
>>-- Len
>
>You could try this as your select statement:
>
>SELECT *,DELETED() AS delrecflag FROM yourtable


Thanks Fred... you're a genius.. I should have thought of that.. the solution is pretty simple in an abstract way.. I kept looking for a property on the row.. duh...

Thanks again..
-- Len
Previous
Reply
Map
View

Click here to load this message in the networking platform