Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Non-structural compound index
Message
De
01/10/1998 08:21:48
 
 
À
01/10/1998 08:07:30
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00142746
Message ID:
00142749
Vues:
27
>Ok, my turn to ask for help. But first a short quote from VFP help:
>Subject: INDEX ON eExpression TAG TagName OF CDXFileName
>"If a compound index file has already been created and opened, issuing INDEX with TAG TagName adds a tag to the compound index file."
>Ok, so far I follow. But the problem I encounter is trying to add a tag that has already been added. How do I find the existing tags?

Use the TAG() function; iterate through the tags starting at 1 and going up with each sequental return; TAG() will return an empty string if a tag number beyond the last defined tag for the CDX is passed. Example:
USE MyTable INDEX MyTable.CDX, NonStruc.CDX
nEnumTagCtr = 1
DO WHILE ! EMPTY(TAG('NonStruc', nEnumTagCtr))
   ? TAG('NonStruc', nEnumTagCtr)
   nEnumTagCtr = nEnumTagCtr + 1
ENDDO
You can also iterate a FOR loop up to TAGCOUNT(), but it's only there for backwards dBASE compatibility, and I don't know the syntax for specifying which of several CDXs to return the TAGCOUNT() for.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform