Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote View Update Conflict
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00119815
Message ID:
00119835
Views:
16
>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.

More data: we changed cZip on the backend from VarChar(10) to Char(10), and it started working. Very strange, especially considering that City and State are both VarChar, and worked fine.....
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform