Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Seek in a View
Message
 
To
04/09/2002 07:43:41
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00695819
Message ID:
00696542
Views:
13
Hilmar,


>>Can you tell me how to use the sys(2015) to name my index. I am haveing trouble with it.
>
>You have to store it to a variable. Something like this (not tested):
>
>
>local lcIndexName
>lcIndexName = sys(2015)
>use MyView
>index on MyField to (lcIndexName)
>...
>* Do something with the indexed view
>...
>use in MyView
>erase (lcIndexName + ".idx")
>
>
>But consider Sergey's note about using CDX - that should be simpler.

Careful here. ".CDX" files can exist separately from Structural (Compound)Indexes and are called just Compound Indexes then.
INDEX ON cMyField TAG cTagName OF (lcIndexName) would do that.

I think you knew it, but it looked some confusing ...

PMFJI, Peter

>
>You may still require the above technique for some other temporary files.
>
>Hilmar.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform