Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Non-structural compound index
Message
From
01/10/1998 08:21:48
 
 
To
01/10/1998 08:07:30
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00142746
Message ID:
00142749
Views:
26
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform