Zeoslib Portal

Thanks Michal for your answer.

TStoredProc = TZStoredProc ???

i get the message:

"SQL Error:Procedure spGetLogin can´t return a result set in the given context"

Hi,

i have a MySQL store procedure:

CREATE PROCEDURE spGetUserData
( IN Userid INT )
BEGIN
SELECT * FROM tableA WHERE id = Userid
END;
-- SO SIMPLE

in the zQuery
QueryA.SQL.Text := 'call spGetUserData';

Compile/run and dont work!! why?

Hi, iam try develop with ZeosLib but it is hard. I have a MySQL store procedure: [font=Courier New] CREATE PROCEDURE spGetLogin ( IN sUsername VARCHAR(32), IN sPassword VARCHAR(32), INOUT iUserId INT, INOUT iReturn INT ) BEGIN SELECT iReturn=userrol, iUserId=sysuserid FROM directorio.estsysusers WHE...