>>>>Thank you, Yuri. What is not clear (and maybe I am missing something) is how do you specify an alias name that will be assigned to the returned query?
>>>
>>>You're not getting a cursor this way. You're getting a recordset.
>>
>>I suppose there is a way then to convert this recordset to a cursor, right?
>>
>>UPDATE. I think to convert a recordset to a cursor I would need to use a CursorAdapter. So I am back where I started :(.
>
>If I remember it correctly, one can also use 'vfpcom:
>o = CreateObject('vfpcom.comutil')
>ors=CreateObject("adodb.recordset")
>.....
>? o.RSToCursor(oRs, 'cursorname')
>
>Not to mention you can scan recordset and process it record by record.
I will try VfpCom; never heard of it. Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham