Perry,

First, you need to make sure the cursor is actually created as a temporary file instead of just as a filter of the table it's based on. In VFP 5.0 you can do this using the NOFILTER clause, as in SELECT * FROM mytable INTO CURSOR temp NOFILTER. In VFP 3.0 or earlier you can add a dummy field, like this: SELECT *, ' ' AS Dumyy FROM mytable INTO CURSOR temp.

Once you've created the cursor you need to make it read/write instead of read only. Assuming you've created a cursor named temp, you can do this:

USE DBF('temp') AGAIN IN 0 ALIAS temp2
USE IN temp
SELECT temp2

Temp2 is now a read/write cursor which you can index just like a table.


>I'm not entirely sure how to index a cursor, the ones I'm using come from an SQL-Select statement