>CCing to me asking my idea about SQL ? SQL select would truncate it because it's creating a free table. If you want to do SQL + preserve longfieldnames then change your SQL syntax to create a view :
create sql view mynewview as ;
> select ...
I wouldn't create a table but a view for something I could SQL select. Still if you need a table, you have afileds(), create, alter, drop etc series of handy commands :)
>Cetin
Or you can use COPY STRU TO mytable DATABASE mydbc,
then APPEND FROM your dbc table, or SQL to cursor from dbc table, and then APPEND FROM DBF(), depending on what you're doing to retain long field names...note that cursors are useful here since they use long field names...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.