Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rebuilding indexes
Message
From
23/10/2000 15:44:15
 
 
To
23/10/2000 15:04:49
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00433093
Message ID:
00433135
Views:
13
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform