Problem with Stored Procedure execution

--=======AVGMAIL-41BB23A52A7D=======
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0013_01C4DFA8.E5A62FF0"

------=_NextPart_000_0013_01C4DFA8.E5A62FF0
Content-Type: text/plain; charset=Windows-1252
Content-Transfer-Encoding: quoted-printable

Hi , Sorry for my English,

My configuration is:
Win2000 SP4, Mysql server and clients alpha 5.0.1, MyOdbc 3.51.10
Well, when I try to execute a simple SP like this:

CREATE PROCEDURE `db01`.`Sp01`()
BEGIN
SELECT nome,cognome FROM TbAna;
END

I got the "famous" error message :=20
Error Code : 1311 SELECT in a stored procedure must have INTO

I've already read about it on your site

MySQL Bugs: #2273: SELECT in a stored procedure must have INTO and

MySQL Bugs: #2658: SELECT in a stored procedure must have INTO
My questions are the following:
When I call Sp01 from the consolle (mysql > call Sp01();) or from MySql =
Query Browser 1.1.2 it works (I got a resultset)
but when I try the same from VB6 (with correct syntax) or from other =
apps such as SQLyog, EMS, ecc. I got the error (err.1311) ??
Well I've read everything about it in the web.=20
Someone talks about Client Flags (CLIENT_MULTI_RESULTS ON) but I seem =
that it can be set=20
only by C API (mysql_real_connect(&mysql,...,CLIENT_MULTI_RESULTS);) and =
I would like to resolve using ODBC.
So, setting client flag is the solution ? Can I set that in MyOdbc ? =
I've to wait for 3.53 release ?
Why I got result with consolle and no result with other apps or VB ? =
Have you a solution ?

Thank in advance=20

Gabriele Zelasco (Italy)




------=_NextPart_000_0013_01C4DFA8.E5A62FF0
Content-Type: text/html; charset=Windows-1252
Content-Transfer-Encoding: quoted-printable



charset=3Dwindows-1252">