Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reindex all tables in the database
Message
From
18/09/2004 15:51:06
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
18/09/2004 12:35:17
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00943748
Message ID:
00943770
Views:
18
>There is a tool called DIRT but it doesn't seem to work with VFP8. Other than manually putting the table names into the code with a REINDEX command, is there a way to loop through the database and do this autumatically?

With adbobjects(), you can get a list of tables in a database.

Another alternative is adir() - with the assumption that all tables in the database are in the same directory. adir() will also process free tables, which may or may not be what you want.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform