Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Alternative to packing a table
Message
De
29/07/1999 12:43:53
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Alternative to packing a table
Divers
Thread ID:
00247762
Message ID:
00247762
Vues:
46
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform