Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Field get cut at 10 chr...
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00524123
Message ID:
00524129
Vues:
16
>We are doing a transfer of data from VFP database (DBC) via a remote view with ODBC. What we are doing is transfer data to an another table.
>
>Select ViewFld1 as MyLongNameField1 from ViewRemote into curosr MyTmpCursor
>select MyTable
>Append from dbf("MyTmpCursor")
>
>
>The result of my cursor cut the field name to 10 chr. (MyLongName)?
>Why? Is this normal?

Is the ViewFld1 length of the first record 10 characters? If this is the case, you might want to force it to be the max length of the field.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform