Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Seek in a View
Message
 
À
04/09/2002 07:43:41
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00695819
Message ID:
00696542
Vues:
12
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform