General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only