>>>>>I am in a form and I perform a select statement and change my cursor. Now I am trying to "set order to tag tag_name" and I get an error saying "file in use".
>>>>>What do I do?
>>>>
>>>>Code sample is necessary.
>>>
>>>ok...
>>>In form1
>>>select * from table into cursor anycursor
>>>set order to tag last_name
>>>-------
>>>this works from the command window.
>>>
>>>In form2
>>>In another form when I have some radio buttons that lets the user
>>>set the tag. I do this with..
>>>do case
>>> case optiongroup1.value = 1
>>> set order to tag last_name
>>> case optiongroup1.value = 2
>>> set order to tag phone_num
>>>endcase
>>>
>>>After my tag has been set, my "anycursor" from the select
>>>has changed. What now???
>>
>>Write clear sysntax, please! You should:
>>SELECT sometable
>>SET ORDER TO TAG ...
>>else you don't know in what table you set the order.
>
>My SET ORDER TO TAG could be setting the order to the TABLE that is active or the active CURSOR (this crusor is from the select).
>Will not the SET ORDER TO TAG set the order to the current avtive
>cursor or table provided the TAG names are there?

Yes, but it's good idea to identify active area. BTW, you cannot have tags for cursor immediately after SELECT_SQL (you must USE it AGAIN and INDEX ON .. TAG).