Hi Sergey
AERROR returns a single value of 1 - which will be the record number I am trying to delete. So it does appear to be a commit error.
Barry
>What's the error ( AERROR() ) in TABLEUPDATE()?
>
>>I have a view based on tables A,B,C. Only the fields in A are set to be updateable. I can add and edit without any problem. If I delete a record and try to update the base tables the update fails as does the subsequent Requery(). I have been hunting around on UT and have seen a suggestion that this is a known issue - but I can't identify a work-around. Can anyone help? Sample code snippet below
>>
>>
>>delete next 1
>>mytest=TABLEUPDATE(.T.)
>>* mytest returns .f.
>>REQUERY("v_myview")
>>* Fails with cursor contains uncommitted changes
>>
>>