Naomi/Sergey

Between your two bits of advice I have got there. The error message was that I did not have key columns specified for other tables in the view - even though I was not needing to update the underlying tables. I had assumed that I did not have to set the key fields. But it appears to be necessary to identify all key fields even if underlying tables are not being updated.

Thank you both for your help. It never ceases to amaze me how I always get a solution from you guys!

Barry.
(I will mark this message as the answer if that is OK?)

>>Sergey
>>
>>The code I am using to get the error info is as follows:
>>
>>

>>jl=TABLEUPDATE(2,.f.,"v_materialstock","myerror")
>>jl returns .f.
>>myerror[1]=1
>>

>>
>>Aerror() does not have anything in it as no error seems to have occurred - just a failed update. Sorry if I am not understanding you.
>>
>>Barry.
>>
>

>llStatus = tableupdate(..)
>
>if not llStatus
>  =aerror(laError)
>  =messagebox("Error " + laError(1,2))
>endif
>