>>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 Moore
Clientelligence