Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Reindex all tables in the database
Message
De
18/09/2004 15:51:06
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
18/09/2004 12:35:17
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00943748
Message ID:
00943770
Vues:
17
>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)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform