Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Delete Tag problem
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00183249
Message ID:
00183254
Vues:
19
Esteban,
Every time you add a TAG to the CDX it stays until you DELETE TAG ALL as you have seen. If you want temporary indexes, then use IDX files. If you're only using a portion of the table, use a cursor and index it on the fly.

HTH
Barbara


>Hi all,
>I have a temporary index to a table in one process. And when it is not useful I delete it.
>But... Taking a look to the directory, I can see that the .CDX size is very large.
>My code is:
>
>Use mytable Exclusive
>INDEX ON myfield FOR mycondition TAG aux
>...
>... && my process here
>...
>SELECT mytable
>DELETE TAG aux
>
>Any suggestion ??? Thanks in advance!
>
>Note: My table have 20 records and the size is 2K. The CDX file have a size of 9400K -- IMPOSIBLE!!!!!!! If I do a DELETE TAG ALL command the .CDX go to 0.3K
Barbara Paltiel, Paltiel Inc.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform