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.
If it's not broken, fix it until it is.
My Blog