>Hi Naomi,
>
>With the following code, I get an update conflict...
>
>
>My other option has been to do a parent table record delete followed by a tableupdate, but it is not working.
>
>My code:
>

>SET MULTILOCKS ON
>CURSORSETPROP('Buffering', 5, "stockbook")
>select vuestock
>DELETE
>TABLEUPDATE()
>

>
>Thanks very much,
>
>Steve

Hi Steven,

Something is wrong here. The view is opened in 3 buffering mode by default, though I always prefer to use table buffering for the view. You don't need to buffer underlying tables as well (this is called 'double buffering').

In addition, the tableupdate needs to include parameters and we should always test its return value, e.g.

SET MULTILOCKS ON
CURSORSETPROP('Buffering', 5, "vuestock") && assuming that vuestock is a view
select vuestock
DELETE
if not TABLEUPDATE(.f., .f., 'ViewStock') 
  aerror(laError)
  =messagebox('Error occurred " + laError[2])
endif