>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)