Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trimming Values from Fox to Oracle
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00570333
Message ID:
00570438
Views:
23
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform