Hi everybody,

I have a form with a grid. In the DE of this form I select records into the cursor from SQL Server using SQLExec. I then do
select * from csrResponses into csrResponses readwrite to make sure my cursor is read write.

Now the fun begins. Near this grid I have Add, Edit, Delete buttons. I delete some records with delete command, they disappear just fine. (Form's deleted status is set to ON) I then Add a new record with Append BLANK , replace ... and all deleted records re-appear!!!

Is it a bug in VFP? I'm going to try with Insert Into then, but the behavior is very strange.

Thanks in advance.

So, the question is - is it OK to delete and add new records to cursor without re-appearing of the records?

UPDATE.Insert command didn't fix this behavior.

See the initial grid, then grid with deleted records, then grid with record added.