Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement