Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
RemoteView
Message
De
26/01/2011 05:15:53
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
26/01/2011 03:42:26
Ed Hizon
Skswood Sdn. Bhd
Kuala Belait, Brunei
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Oracle
Application:
Desktop
Divers
Thread ID:
01497412
Message ID:
01497415
Vues:
53
>Dear all,
>
>I have created a remote view and the connection to an Oracle database table and the connection was successful. When editing the record which fields are mark as updatable in the view created but before I could go to the next record the error popup as "Update Conflict In Cursor XXXX". What is lacking in my remote view.

First off, your buffering is set to 3, so it issues an automatic tableupdate() whenever you attempt to move to another record. You should try to do the tableupdate yourself, check what value it returned, and if .f., check the reason with aError().

It's possible that you've created a new record, and there's no PK value set (either via a default value, or as an identity column, or whichever method you picked), or if it's an existing record, your view's where clause is set to all updatable fields (which is, IIRC, the default), and someone else has changed the value in one of them while you were sitting on this record. Depending on your strategy, you can set this to just key (if you want to make sure your changes get saved and don't care if you overwrite someone else's changes), or key and timestamp (if you want to issue an error if anyone else edited the record between your reading it and your attempt to write it).

So check your tableupdate(), your PK and your where clause.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform