>
>I want to execute SP in the database to return VFP cursor. I found this sample in WiKi
>
http://fox.wikis.com/wc.dll?Wiki~VFPOleDBProvider~VFP>however it returns Record Set. Is my only way to receive record set first and then convert it to a cursor?
>
>In other words, assuming I have the following SP in the database
>function test_sp
>select * from Users into cursor curTest
>return
>
>I now need to execute this SP and return this curTest cursor.
>
>Thanks a lot in advance.
In my code I don't return cursor from VFP SP. I return and XML string. You see, I use ASP.NET to call VFP SP and ASP.NET does not understand VFP cursor. So I return XML to ASP.NET then deal with XML in ASP.NET. Would example of how to do that be helpful to 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