Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How I Know if an INDEX TAG exist?
Message
 
 
À
11/03/2002 15:18:43
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00631162
Message ID:
00631166
Vues:
22
>How can I know if an INDEX TAG exists?. I want to delete an especific index tag (if it exists, of course) before create a new one.
>
You can use TAGNO() function
IF TAGNO("myindtag") > 0
  * Tag 'myindtag' exists
ENDIF
However it's not good idea to delete and recreate individual indexes because it causes index bloat and slows down data access. Maybe there's another way? Why do you need to delete and recreate an index?
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform