Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How To Add Index To A Database At Runtime
Message
De
18/10/2010 15:16:40
Raza Malik
Universal Accounting Software
Edgewater, New Jersey, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
How To Add Index To A Database At Runtime
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01486000
Message ID:
01486000
Vues:
143
Hello Everyone....

I have a database with multiple tables. One of the table hav 1.5 mil records and 10 indexdex.
I have an indexing function which pack the tables and then reindex. The index was taking a very long time.
Before packing the table, I decided to use DELETE TAG ALL command and then created brand new index tags
by using INDEX on... TAG ??? command. It did speed up the process but in a runtime version, I get the following error:

Index Tag ??? was not found. Would you like to add the Index Tag to the database ???.

What command I can use to add these index to a databse programatically?

Any help is appreciated. Thank you in advance...

Raz
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform