>Mark,
>
>Thanks for the reply. What does setting the Update type = 1 do to help the trim? I guess I don't fully understand the Update type option.
>
>Matt
When you set the update type to Key and Modified Fields, VFP will do a comparison of the data in your cursor to the data in the table being updated. This is what triggers the error because the data in the VFP cursor has spaces padded to the length of the field and the data in the Oracle Varchar field does not. So VFP sees this as an update conflict.
See KB article:
http://support.microsoft.com/support/kb/articles/Q170/1/29.ASP
Mark McCasland
Midlothian, TX USA