>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
Steve Peacocke
Development Team Leader
Prudential Assurance