MySQL Query error

[thejhorse]

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?

[miab3]

Use the TStoredProc(and TParams and ExecProc or Open), Luke.

Michal

[thejhorse]

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"

[miab3]

@thejhorse,

You certainly have tried something like this?:

Code: Select all

ZStoredProc1.Close;
ZStoredProc1.StoredProcName:='spGetUserData';
ZStoredProc1.Params[0].Value:=50;
ZStoredProc1.Open;

Michal

[EgonHugeist]

thejhorse,

sorry for the late answer. Did Michals adivice help?

I've made some patches for the MySQL Stored-Procedures to be able to execute them with the TZQuery-Components too. But these Patches are only available on SVN..