Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Field get cut at 10 chr...
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00524123
Message ID:
00524147
Views:
18
VFP has a maximum field name length of 10 (unless table is inside DBC).

>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?
Nigel B Coates
NBC Software Services
Dublin, Ireland.
eMail: Nigel.Coates@NBCSoftware.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform