Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update Conflict
Message
De
23/11/2001 03:12:11
Alexandre Palma
Harms Software, Inc.
Alverca, Portugal
 
 
À
22/11/2001 22:46:19
Joel Hokanson
Services Integration Group
Bellaire, Texas, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00585040
Message ID:
00585062
Vues:
13
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform