I think I worked it out yesterday.
I was using a DO WHILE loop around the view and doing a TABLEUPDATE(0, .T.) on each record. Of course if SET DELETED was OFF then the deleted rows would get deleted properly, but if it was ON, then they would get skipped by the DO WHIE and so never get updated!
>Could you tell more on how do you define the view and its properties, what kind of database/connection, what buffering do you use?
>
>>Hi,
>>
>>I've got a form with a grid on it. The grid is based on a view. the view is opened with table buffering on. I delete a record in the view (simple DELETE command), then press a button that does a TABLEUPDATE(0, .T.), which returns .T.
>>
>>However, the record does is still there when I open up the form again.
>>
>>If I SET DELETED OFF prior to the TABLEUPDATE() the record does get deleted!
>>
>>As this is coming to the end of a very taxing day I would appreciate it if someone can explain to me why SET DELETED OFF makes it work.
>>
>>Thanks,