Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update Conflict on Requery of View
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00376934
Message ID:
00377404
Views:
34
>Erik
>
>Thanks for all your help.
>
>I finially got this to work with out update conflict error, although I'm not sure if this is how it supposed to work. Aftering issuing a tableupdate() on the view, I then issued a tableupdate() on the base table. This seems to work. Do you see any problems with this?
>

Ahhh- ok.

If you have the base table open and buffered in the same datasession, then yes, this is what you have to do. Generally, there is no need to have the base table open in the same datasession unless you are using it for other purposes (the view will open its own copy if there is not one open). What's happening is known as double buffering: the writes changes to the buffered copy of the table, but they are not written to disk until the table is TABLEUPDATEed as well.
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform