>>>>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???
>
>After your select statement, your active work area is the area that contains the cursor. There is no automatic tag created. You'll have to create it with an "Index on ...." command.
>
>Bill

Hi Bill... thanks for that information... it helps...
any question... How can I make my cursor a "view" so I can edit
the information?
My code is...
SELECT * FROM TABLE INTO CURSOR ANYCURSOR...