Hi Garrett,

This is indeed very strange. Did you try scanning through the view and using REPLACE for each record rather than the REPLACE ALL?

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