Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
COPY STRUCTURE & long field names
Message
From
18/06/2001 05:34:58
 
 
To
18/06/2001 03:51:30
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00520468
Message ID:
00520476
Views:
17
Kari,
In order to support long field names, your table must be added to a DBC. There are several possibilities:
*-- the following works in VFP6, I'm not sure about 5.0
COPY STRUCTURE TO < YourTable > DATABASE < YourDbc >
or
AFIELDS(laFields)
CREATE TABLE < YourTable > FROM ARRAY laFields
or
SELECT * FROM < YourTable > INTO TABLE < YourTable > DATABASE < YourDbc >
HTH
>Hi all!
>
>My problem is that Visual Foxpro 5.0 doesn't support longer field
>names than 10 characters when I use the COPY STRUCTURE command
>as follows:
>
>USE remote_view && this has long field names
>COPY STRUCTURE TO temp_table.dbf
>
>Now when I look at the "temp_table.dbf" there are only
>the first 10 characters left for each long field name.
>
>Is the only solution to change database field names to
>shorter ones?
>
>Thanks in advance.
>
>Kari
Daniel
Previous
Reply
Map
View

Click here to load this message in the networking platform