>>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.
Erik Moore
Clientelligence