Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Rebuilding indexes
Message
De
23/10/2000 15:44:15
 
 
À
23/10/2000 15:04:49
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00433093
Message ID:
00433135
Vues:
14
>I have a program that rebuilds indexes in a free table. It deletes the 'cdx' file and then reads index information stored in another table to rebuild the index file. If index changes need to be made, they are modified in the information table and then the rebuild program is run.
> Tables that belong to a database, however, have their index information store in the database dbc file as well. In order for the program to rebuild the indexes in database table it would also have to update the dbc file. This looks like it will work but does not seem to be the best approach. Is there a better way to delete and rebuild indexes in a database table?

Purchase SDT (Stonefield Database Toolkit) from www.stonefield.com - it does this and a whole lot more, and is worth every penny you spend on it, since you can incorporate its functionality for reindexing, packing, repairing, validating and updating databases anbd free tables intoyour own applications.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform