>Ok. There is a little change of behaviour. The problem only occurs when deleting the LAST ROW in the Grid. Deleting other records works properly. > >>>Using Remote Views, Set Deleted On doesn't to seem work properly on Grids. Here is the scenario: >>> >>>I have a grid that uses RV as recordsource. The RV is buffered. Using command buttons, I do Inserts and deletes. No problem with Inserts. However, deleting a record, Skip, and then Refresh... the record is still displayed in the grid. Only upon issuing TableUpdate gives the expected behaviour. Am I missing something here? >> >>Two possible problems occur to me: >> >>

SET DELETED ON is scoped to the current datasession. Try issuing SET DELETED ON in the current form. >>

DELETE, just like doing any other change, should be followed by TableUpdate(). Otherwise, the change (deleting the record, in this case) isn't comitted to disk. >> >>HTH, Hilmar.

Hi Jess.
I had similar elusive behavior conserning RV with table buffering. Add to this a grid and a couple of relations and you get an upredictable mixture. I decided to stop groping my way to the end of the project and create an artificial table buffering which consists of a RV with the record buffering and a copy-cat cursor where in fact you do all the changes, then save them to RV, to SQL server.
Kamil.

A moment of silence is our cosmic reset button.