>>>>Yes it does. If you use both ORDER and then TAG, the seek command looks for an index called TAG. Try it.
>>>
>>>create table testorder ('field1' c(10))
>>>index on upper(field1) tag testseek
>>>seek 'Test' order tag testseek
>>>
>>>No errors there, I'm not sure what you mean.
>>
>>Woopsy. You're right. It would help my testing practice if I tested with a tag that really existed. I had tested with the equivalent of the following:
>>
>>create table testorder ('field1' c(10))
>>index on upper(field1) tag testseek
>>seek 'Test' order tag testorder
>>
>>Sorry, Jimmy.
>>
>>I would go with Mike's first suggestion: ensure that the alias is current before issuing your SEEK, or better yet, use the IN clause.
>
>That's ok. Thanks guys for the rescue...Mike was right, the view 'trancustin' wasn't initially selected. "SELECT trancustin" as the 1st line of the init did the trick.
>
>Thanks again
>JD

Excuse me - the 1st line of LOAD.