>>I would imagine this:
>>SELECT * FROM mytable INTO CURSOR mycursor
>
>>would be faster than:
>
>>create cursor mycursor (field definitions)
>>select mytable
>>scan
>> scatter memvar memo
>> insert into myCursor from memvar
>>endscan
>
>SELECT * FROM mytable INTO CURSOR mycursor
>append from ()
>
>might be a better comparison...
>
>regds
>
>thomas

Hi Thomas,

I see your point (I never think of using APPEND), maybe I should have done it like this:

SELECT * FROM mytable INTO CURSOR mycursor NOFILTER

create cursor mycursor (field definitions)
APPEND FROM mytable

Anyhow, I would still prefer to do it using SQL as the other way I would need to know the table definition and if the table structure changes it would break my code. But then again I could get around that problem by creating an array of the table structure and then creating the cursor from the array.