Hi Erik,
I did what you suggested. I found that the tableupdate was not committed because
the view was read only, how could that happened, the error number is 111,
it says 'Cannot update the cursor'. Any thoughs on that one ?
>Even though you are forcing updates, there are still several situation where TABLEUPDATE will fail: unique key violation, trigger failure, locked table header or record, etc. You should always check the results of TABLEUPDATE() to be sure and catch this...
>
>
>>Thanks much for your answer Erik,
>>I am not doing that because I and forcing a tableupdate with
>>=TABLEUPDATE(1,.T.), but I will check that. The only reason I think that could
>>make =TABLEUPDATE(1,.T.) to fail is somebody having a LOCK in the record, which is weird because this table is only updated through views.
>>
>>Thanks again, Erik.
>>
>>
>
>>>Are you checking the return value of your TABLEUPDATE()?
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould