Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP OLEDB Provider - quick question
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
01116144
Message ID:
01119299
Vues:
11
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform