The only way I see it working is if the length of the value is always the same as the width of the field. The problem arises in that spaces are added to pad the width to match the width of the field. When VFP updates, it will compare "123" [VFP side] to "123 " [Oracle side] and get FALSE [returns an update conflict error]. So as long as all values are the same width as the field, updates will fail. This defeats the purpose of a varchar field.
>Hi Mark,
>
>Thanks for your reply.
>
>Will this option work if the key field is a varchar2?
>
>Paul
>
>>
>>I prefer the option to change the remote view update type to Key Fields only in order to avoid this problem.
Mark McCasland
Midlothian, TX USA