Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Find out if index is filtered
Message
De
31/07/2001 07:20:58
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00537153
Message ID:
00537678
Vues:
13
>>>>...
>>>>Is there a function to tell me what the filter expression is?
>>>>
>>>>TIA, Hilmar.
>>>
>>>Take a look at the code for the reindex utility on my website... www.waynemyers.com
>>
>>Sorry, I just downloaded the code, but I can't figure out which commands (if any) save the FILTER expression for the index.
>>
>>Hilmar.
>
>These two lines are probably the ones of interest for you...
> m.ctagname = UPPER(TAG(lnTag))
> m.ctagexp = UPPER(SYS(14, lnTag))

Wayne,

It seems to me there has been a confusion between the INDEX EXPRESSION and the FILTER EXPRESSION (for the index). I was asking for the FILTER EXPRESSION, which can be obtained through the function FOR() (I learned this in other replies to my question). I think you should add this to your sample code: it seems to me that you save index name and expression, but not the filter expression. I didn't test this, but I don't see any code to save the filter expression. Example: if I index with a command like: INDEX ON CLIENTCODE TAG CLCODE CANDIDATE FOR NOT DELETED(), I think the index name (CLCODE) and the expression (CLIENTCODE) would be maintained, but the filter (NOT DELETED()) would not.

Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform