What is the difference between the two tables? One is created by SQL and is not associated with the DBC and the other is created by sort or copy and is not associated with a DBC either. Why dose the copy / sort have the 10 character name limitations when creating output file and SQL does not?

>What about

SELECT * FROM mytable ;
>  ORDER BY field1, field2 ;
>  INTO CURSOR tempfl NOFILTER
>SELECT mytable
>ZAP
>APPEND FROM ( DBF("tempfl") )
>

>
>>Dilemma! I’m using VFP7. I have a table as associated to a DBC with several column names longer than 10 characters. When I do a
>>
>>Sort on field1, field2 to tempfl
>>Zap
>>Append from tempfl
>>
>>The field names get truncated to 10 characters and when you append back you lose the data.
>>How can I eliminate this issue?
>>What is an alternative way of doing this?