If you are doing this in a form or grid, after you delete the record, you need to move the record pointer with a SKIP, SKIP -1, LOCATE, GO BOTTOM, etc. Then refresh the form and/or grid. You are correct about the record only being flagged as deleted and not permanently removed until the table is PACKed.

Are you sure you checked the box to SEND SQL Updates when you created the view? Identified the Key and updatable fields? If you run an AERROR(laError) what info does the array, laError, have in it? [assuming the tableupdate returned false].

>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