Kari,
In order to support long field names, your table must be added to a DBC. There are several possibilities:
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