Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with Deletion Mark on Grid
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00351235
Message ID:
00351283
Views:
32
Hi George.

>> After deleting a record on the grid, I perform the following select statement:
SELECT * FROM WHERE DELETED() INTO CURSOR c1

The resulting cursor has no records. Even more confusing is when I try DELETED('remote_view') and the record pointer is on the deleted record, it returns .F.
Any ideas why this is happening? <<

Yes. The SQL statement works on the file that is on the disk and not what is in the buffer. Until you issue a tableupdate(), the deleted record is only deleted in the buffer. You could try saving the record pointer of the grid's RecordSource and issuing a COUNT FOR DELETED() TO lnDeleted and restore the record pointer afterward. This command will operate on the records in the buffer.

Marcia
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform