>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement