>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")
select vuestock
DELETE
if not TABLEUPDATE(.f., .f., 'ViewStock')
aerror(laError)
=messagebox('Error occurred " + laError[2])
endif
If it's not broken, fix it until it is.
My Blog