Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
...index does not match the table. Delete the index ...
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00866376
Message ID:
00866427
Vues:
25
>Well, the tables in question have a whole shed-load of (sometimes compound) indexes. Is there a way of preserving their definitions so that I don't have to go into the table builder and manually and laboriously create the indexes all over from scratch? - Especially if this should happen more than once, and to several tables, as has just happened to me!

I keep a whole folder full of indexing PRGs, named by the tables they're used for. They all look very similar, about like this:

SET EXCL ON

USE? (get the table you want)

DELETE TAG ALL

INDEX ON field1 TAG etc.
INDEX ON field2 TAG etc.

where "fields" can be complex/compound code
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform