>>>thx~
>>>but i want to ask what is the type of table that export from those command?
>>>is DBase 4.0 or 3.0 or others?
>>
>>Hi Wai,
>>
>>If you ran your SQL statement in FPD 2.6 it would be Fox2x type, otherwise it would be VFP type. You can convert it to FPD 2.x type using this command:
>>
>>COPY TO (lcTableName) with CDX type 2.x
>
> Correction: type Fox2.x

Correction: TYPE FOX2X