>>>>>>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...
>
>I would start by looking at the View Designer. You'll have the option of making an updateable view. I've only done it once, so I probably am not the best one to answer your question. Your code above will create a standard sql cursor. You'll need to add to it to make it a view. there is a CREATE SQL VIEW ... command that will get you to the designer.
>
>HTH...Bill


Thanks Bill... I will do that... thanks again...Rob