>You can use CursorAdapter with ADO.
>
Sergey,
I let my colleague Jim explain our idea, but basically I don't want to use CA. I want to write some code to execute SP on the server and just bring the result back to VFP application.
It's all for the managers screens, which are very slow now. You probably saw my recent threads where Fabio participated. In my tests the best result was ~30 seconds, that I think it's too long. When data are local, the code runs in less than 5 seconds.
>>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.
If it's not broken, fix it until it is.
My Blog