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