Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update Conflict
Message
From
23/11/2001 03:12:11
Alexandre Palma
Harms Software, Inc.
Alverca, Portugal
 
 
To
22/11/2001 22:46:19
Joel Hokanson
Services Integration Group
Bellaire, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00585040
Message ID:
00585062
Views:
12
Joel this is the description on the help for this error.
An optimistic locking conflict has been detected while trying to update a view.

Make sure your update key is valid.

If you want to commit your changes to the base table(s), call TABLEUPDATE( ) with lForce. This will overwrite the changes made to the base table since the view was last fetched.

To discard the local changes made to the view, call TABLEREVERT( )
How are you setting the sql update where clause key field only, key field and updatable fields...

>I am using remote views in VFP 6 and search for a specific reord in SQL 7.0 and then update the record.
>
>It seems to run fine for a few records the I get an "Update Conflict" and it locks VFP and I can not even Quit VFP.
>
>THoughts PLEASE
Alexandre Palma
Senior Application Architect
Previous
Reply
Map
View

Click here to load this message in the networking platform