>>>>>I have a segment of code that before calling SEEK() it checks if the current index tag is of character type. So what I do is the following:
>>>>>
>>>>>
>>>>>if type(tag()) = "C"
>>>>> SEEK("something")
>>>>>endif
>>>>>
>>>>>
>>>>>An issue I ran into is when the index key is something like
>>>>>UPPER(SUBSTR(myfield,1,20)), the type(tag()) returns "U". I can change the code above to check that the Type(tag()) is not "L" or "N" and then call SEEK(). But I am thinking that perhaps there is a better approach.
>>>>>
>>>>>If you can suggest something alternative, I would appreciate it.
>>>>
>>>>If you want to check for the type of index key expression then you could use:
>>>>VARTYPE(EVALUATE(KEY()))
>>>
>>>Ed, Thank you very much! This works. Sorry that I gave Naomi the solution stars, I didn't notice your message first, and you were first. I owe you some stars then <g>.
>>
>>Frankly, I would prefer something more material :).
>
>Ok. Next time I am in NYC, we can do lunch, I am inviting.
Thank you, sir.
Edward Pikman
Independent Consultant