Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SEEK command can go yonder!
Message
From
25/06/1998 19:30:49
 
 
To
25/06/1998 17:08:34
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00111477
Message ID:
00111761
Views:
34
>>>Anyone ever use the SEEK command? Alright, who has used it in the following format:
>>>
>>>SEEK myvalue ORDER TAG mytag OF mytable IN mytable
>>>
>>>????
>>>
>>>My goal -- simple. Move the record pointer in a table other than the current workarea; it saves storing the current alias, selecting the target table, seeking, and then selecting the original table. Only problem is -- doesn't seem to want to work. I get errors including "Variable COMPANY not found" (COMPANY happens to be a field in mytable, but this command above doesn't have anything to do with that field as far as I can tell).
>>>
>>>I have a primary index key using a CDX file set to 'mytag'.
>>>
>>>What's strange is that I've actually gotten this command to work before, but then that one quit working.
>>>
>>>Hope someone can clue me in!
>>>
>>>Sincerely,
>>>
>>>Mark
>>>mark@remarkable-systems.com
>>
>>Is "myvalue" a variable or a field reference? If it is a field, try adding the alias to it. (table.myvalue)
>
>
>Fred,
>
>"myvalue" has been both a variable and a literal string, but never a field reference. Does this help?
>
>The strangest part about it all is that this exact command works on another table with similar indices.

No, I just thought you may have had a problem with a memvar being the same name as a field reference. This can sometimes lead to confusion about which value is actually being used (field contents vs. variable contents) for the seek. Sorry.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Reply
Map
View

Click here to load this message in the networking platform