Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP OLEDB Provider - quick question
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01116144
Message ID:
01119299
Views:
12
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform