Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
RemoteView
Message
From
26/01/2011 05:15:53
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
26/01/2011 03:42:26
Ed Hizon
Skswood Sdn. Bhd
Kuala Belait, Brunei
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Oracle
Application:
Desktop
Miscellaneous
Thread ID:
01497412
Message ID:
01497415
Views:
52
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform