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