General information
Category:
Forms & Form designer
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only