Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Possible to return a result set from VFP 7 DBC SP ?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00630987
Message ID:
00631209
Views:
30
Hi Greg.

>Is it possible to return a result set from a VFP 7.0 DBC stored procedure ?

That depends on what you mean by "result set"? If you mean can a stored procedure create a cursor, yes. If you mean can it create and return an ADO record set, yes. If you mean that when it's called from the VFP OLE DB provider, can it return an ADO record set of results, the answer is no -- the stored procedure can only return a single value, and the record set returned by the OLE DB provider has a single record with a single field containing that value.

Doug
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform