>>>>...
>>>>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)