Re: URGENT: return result set in SPs

[Gary Chernega]

>No, not exactly. You can capture a resultset from the stored procedure in a external
> host language, like the C++ API. you just can't capture it in another procedure.
> Also, you can do a SELECT inside a sp, but the results are immediately
> returned....to the client program, not to a subsequent procedure or the calling context.

This will prevent me from migrating from SQL Server 7 to MySql with my Visual Basic 6 code. If results aren't sent back to the calling context, I have VERY little use for Stored Procedures, and thusly MySql in general.

This really needs to be implemented. Using SQL-SPs for SELECT statements rocks. It allows for a single SP to be used by multiple code packages without having to update each when a decision is made to change the query, AND without recompiling source codes due to changes in SP structuring.

If a feature request hasn't been filed, one needs to be.


For now, for me, I am UNINSTALLING MySql until things change or someone gives me a clue how to get a resultset into a Recordset object of Visual Basic 6. (Maybe a C++ library could do this, anybody want to develop it?)