Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View does not send updates.
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00387120
Message ID:
00394417
Views:
10
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform