Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote View Update Conflict
Message
De
21/07/1998 15:06:31
Bob Lucas
The WordWare Agency
Alberta, Canada
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00119815
Message ID:
00119823
Vues:
15
>I have a remote view on an Oracle table, with no special validation on the view. I can REPLACE ALL cCity WITH 'BANGOR' and REPLACE ALL cState WITH 'ME', but when I try to REPLACE ALL cZip WITH '04401', it gets up to a record that was inserted via a Stored Procedure and then gives me an 'Update Conflict' message. If I update this record directly using SQLEXEC or SQL Plus, it has no problem.
>
>Anybody have any ideas for chasing this one down? Thanks. :-)

It may be related to the kind of update that is occuring. That is, key field only, key and modified fields only, etc. If you change this option on the view update tab to key field only, it will probably work fine. However, this option doesn't check to see if any data has changed before doing the update. It affects the where clause that is used and can actually have a big impact on performance based on the indexes and keys that exist.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform