A common reason for this problem is that you have both the view and the table buffered. If that is the case you need to issue 2 tableupdate(): one on the view one on the table. When I use updateable views, I usually add the table not buffered in the DE.

>Hello,
>
>Can anyone please provide syntax that could be used to delete records through a buffered view. The buffering is set to optimistic table buffering [5] in the data environment bufferoveride property. When I run the following code from the click event of a command button it looks as though it works but when I check the underlying tables the record is still there. Also, when you delete a record I understand that it is never gone until you Pack, but with Set Deleted On should you still see the record in the underlying tables.
>***************
>***************
>Set Deleted on
>
>Delete
>
>If Tableupdate()
> Else
> Messagebox(" Delete Was Not Successful ")
>Endif
>
>Thisform.grdCustvw.Setfocus
>Thisform.grdcustvw.Refresh