>SELECT * FROM mytable INTO CURSOR mycursor NOFILTER

>create cursor mycursor (field definitions)
>APPEND FROM mytable

If you compare these two versions, the question is, why copy the whole dataset to a cursor anyway? You could work with the table itself then. An alternative may also be CREATE DATABASE mylocaldatabase and COPY TO ... DATABASE ... optionally even with indexes: WITH CDX. And you don't need a (temporary) local database when only using short field names and copying to a free table.

Bye, Olaf.