Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Trimming Values from Fox to Oracle
Message
 
 
À
18/10/2001 14:01:55
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00570333
Message ID:
00570438
Vues:
24
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform