Bonnie,
I've tried this with SELECT MyView...TABLEUPDATE(.T.) to no avail.
My conclusion is, that not only do I not catch it, VFP dosn't either!
I'm fairly sure that the Insert works, it seems as if it's the records that are in the view when it's initially opened, that are not updated as they should be.
>Peter,
>
>Not a solution, but maybe something else to look at:
>
>> llResult=TABLEUPDATE(2,.T.,"MyView",Errors)
>>
>> * Check if the update returns .T. and handle any records
>> * that did not make it through...
>
>
>By specifying a 2, "an error doesn't occur when a change cannot be committed, and Visual FoxPro continues to process any remaining records in the table or cursor." (straight from the VFP help) ... but your Errors array should contain your error messages. Since you're checking for llResult to be .F. before messing with errors, I assume maybe you're just not catching what the errors are that are causing the problems.
>
>HTH,
>~~Bonnie
Peter Pirker
Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?
(Woody Allen)