>>>>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

Thanks :) It's hard to remember all syntax of all commands :)