>>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?
>
>Why are you indexing the cursor? wouldn't a simply "SELECT INTO CURSOR mycursor ORDER thisfield" do what you want?
>
>Steve
I have to have multiple indexes on this, so the results can be searched.
Erik Moore
Clientelligence