Hello Sergey

Thank you for your reply!

That works (had add the 'cursor' option into the sql). that is a very nice approach.

Thanks again Sergey!


>

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!