>>>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.