Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Returning a cursor from a remote VFP stored procedure
Message
From
19/10/2004 11:31:01
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00952580
Message ID:
00952649
Views:
208
>David,

>You can return only a single value from Visual FoxPro stored procedure in VFP8 and earlier. It'll be possible to return a Recordset in VFP9.

Thank you Sergey, that makes it clear once for all. Unfortunately for us, it is unsure that we can wait until VFP9.
What about a workaround ? Can I build a custom recordset object and have VFP send it as return of a stored procedure, or will VFP only accept to return a known-type value ? After all, when I call a stored procedure through ADO, I can retrieve the result as a single-rowed RecordSet, so it's an object.
I thought about using views too, but how could I make views which can be called only with the parameters I want ? I mean, for instance allowing access to "books by author A" but disallowing access to "all books".
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform