PROCEDURE xxx.yyy can't return a result set in the given context.

[carlos malpica]

Hello friends, who so.

I am updating an application that I developed short while ago (improving component, programming and version of MySQL). I migrated of MySQL 3.23.56 to 5.0.19 because I saw that the benefits are superior and mainly by the possibility of handling stored procedures.

I developed my stored procedures in MySQL-Front 3.2 and there I execute them and the truth I do not have any problem, the problem occurred when I wanted to execute those procedures stored in my application appeared to me the following error:
PROCEDURE xxx.yyy can't return to result set in the given context.

I use components Zeos 6.5.1 alpha CVS as of 13/10/2005 in Delphi 6, already I looked for solution this problem but the truth that I do not give him. somebody can help me?

Thx's.

2006/07/13 13:24 GMT-6:
Making an exhausted search I found solutions for those who use the function mysql_real_connect and this is to add option CLIENT_MULTI_STATEMENTS as parameter to the function but I have not found like doing using it my Zeos components.



Edited 1 time(s). Last edit at 07/13/2006 07:24AM by carlos malpica.