Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems with seek on a view
Message
From
21/08/2000 13:52:26
 
 
To
21/08/2000 13:46:15
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00407408
Message ID:
00407427
Views:
23
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform