>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.....