Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Field get cut at 10 chr...
Message
From
27/06/2001 10:36:21
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00524123
Message ID:
00524129
Views:
15
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform