Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update conflict when updating Sybase SQL Anywhere databa
Message
De
07/11/2007 14:27:12
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, États-Unis
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01267318
Message ID:
01267373
Vues:
14
It has been a long time since I used views but you might check the WhereType property. If you are using anythink but 1 then it could cause this if another user changes the table (I think).

>I have a remote view to update Sybase SQL Anywhere version 5 database. The parent table has a valid primary key and I have selected the updateable field and primary key field and also Send SQL updates is checked. Now when i run the view and try to update the updateable field it gives me error Update confilct. There primary key in parent table is unique and there is no any primary key voilation. I have tried by using different Where SQL clause but no success. Please reply me if someone have some solution to update Sybase SQL Anywhere version 5 using vfp9.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform