>>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.
>
>set a break point on set("deleted") and see if something is turning it on...

Major dah. I was calling another form from these buttons and haven't realized our default is set deleted off (why?). When you made your suggestion, the light went on.