Hi Kam,

Thanks for your reply! But it doesn't work for me even with (report_db)..

After trying a lots combo, I find that I just need to use the table with this:

use c:\temp\report.dbf index c:\temp\report.cdx

then it can generate the CDX at server..

Anyway really thanks for your reply! :-)

Jimi


>Jimi,
>
>The command works for me. Maybe you want to try:
>copy to (report_db) with cdx fox2x
>
>Kam.
>
>> report_db=DATA_PATH+"REPORT.DBF"
>> report_bak=DATA_PATH+"REPORT.BAK"
>
>> close tables
>> copy file &report_db to &report_bak
>> use c:\temp\report.dbf
>> copy to &report_db with cdx fox2x
>> close tables