Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trying to execute procedures through VFP OLE DB provider
Message
From
01/11/2001 14:32:25
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00576274
Message ID:
00576341
Views:
17
Thanks Sergei!!!

Your information was very valuable, and I don't know why I couldn't find that article in MSDN....

But... in the sample, the procedure returns just a variable, through RETURN command. Here is the sample:

PROCEDURE GetValue( par1, par2 )
...
RETURN value
ENDPROC

It is possible to RETURN a cursor?? (I mean any simple query like "SELECT * FROM table"), like that:

PROCEDURE GetValue(par1, par2)
SELECT * FROM Customers
ENDPROC

This code produce the error. Any idea???

Thanks!!!
Dr. Programejos

>Take a look at mskb#Q299820 'HOWTO: Execute a Stored Procedure in a VFP >Database with the VFP OLEDB Provider'.
Carlos A. Granitto
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform