>Dan,
>
>You can't do the COPY TO... because you screw up the link between the table and its database.
>
>Conventional wisdom is to get Stonefield Database toolkit. Or, if you want to learn how and think you can build a better mousetrap, do it yourself (which is what I did, so I could tie it into my own data dictionary).
>
>>I have heard that it is not wise to pack a table on a production system, especially when you're dealing with a fairly large table. ( 100,000+ ). Instead you do something like:
>>
>>PARAMETERS tcDbc, tcTableName
>>USE (tcTableName)
>>COPY TO TEMP DATABASE (tcDbc) FOR NOT DELETED()
>>RENAME TEMP.DBF TO &tcTableName..DBF
>>REINDEX
>>* Or recreate the indexes one by one from a data dictionary
>>
>>1. Is the correct syntax.
>>
>>2. If its correct, is there a problem in VFP 5, where the copy to only copies the first 10 characters of field names.
>>
>>TIA

Thanks for the info. We have Stonefield but have never implemented it in production. Maybe its time.