Select * from mytable into crsTemp NOFILTER
USE (DBF("crsTemp")) AGAIN IN 0 ALIAS mycursor
USE IN crsTemp
SELECT mycursor

>Thanks for your reply.
>
>i think that's for vfp 7 or 8. i foregot to mention that i work with vfp 6 - sorry.
>
>>Select * from mytable into mycursor READWRITE
>>
>>>Hello everybody
>>>
>>>i need to create a cursor through a sql command which is not read-only. i think i have seen a solution here at UT before, but i do not remember it.
>>>
>>>thanks for any help in advance!