Zeoslib Portal

If use debug mode and press F8 before take o lilte pause work.

It is example:

CREATE PROCEDURE `dorepeat`(p1 INTEGER(11))
BEGIN
select @x:=0; -- without this line work in any situation
set @x=0;
REPEAT SET @x = @x + 1;
UNTIL @x > p1 END REPEAT;
END


call dorepeat(100000); -- work
select (@x)

call dorepeat(1000000); --don't work
select (@x)

if don't use "sleep" error message is "Lost connection".
Long the sleep depends by lenght of procedure.

I tray to execute from EMS SQL Maneger and work but from Navicat 2005 not.
Is strange

I use libmysql.dll from that version mysql 5 and renamed to libmysql41.dll. If procedure is short, time to pause maybe small. Doesn't matter contents from procedure.

I have a procedure ex: proced() from mysql command prompter mysql > call proced() work ! mysql > select 1; work ! and work fine. But from delphi with zeos not work correctly. I find “solution” with command "sleep" between "call procd()" and "select1" . query.sql.text:='...

Set ParamCheck with false

look at

http://seegernet.koolhost.de/zeosforum/ ... ght=lookup

and

http://sourceforge.net/tracker/index.ph ... tid=415826