General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only