>>>Here's the problem: I have an SQL statement for which I must index the results.
>>>
>>>If I just SELECT INTO CURSOR mycursor, and attempt to index, I get a 'mytable is readonly' error. (Mytable is the underlying table from which the SELECT was querying).
>>>
>>>I don't want to make the cursor update changes to the base table, so the old USE DBF('mycursor') AGAIN ALIAS whatever doesn't fit the bill.
>>>
>>>I have attempted to SELECT into an array, and then append the results to a cursor, and then index. This works until the query returns a large number of records and then I get 'Too many variables'
>>>
>>>In other situations, I have just used a view and indexed the results of the view, but this statement is too dynamic to use a view.
>>>
>>>How do I handle this?
>>
>>If you call this from a form why not just use radio buttons or combobox or whatever to insert the set order to clause of the query. This way it is dynamic.
>
>My question was how to get the indexes on the results in the first place, not how to arrange the SET ORDER TO statements on the form. By dynamic I meant that the statement is issued with macro expansion, using the results of user chosen query criteria.


Erik,
Again I say why not use radio buttons. How are you getting the User criteria? This is the form I was talking about. You can use the results of the criteria form very easily to create a set order to Cursor. I was not implying that you sort the DATA form.

Sorry for the misunderstanding. Anyway I was out of the country last week and you probably have found your solution.