PROCEDURE can't return a resultset in the given context

[hstijnen]

Hi,
I've just started with ZEOS7 in CBuilder XE. In my app in CBuilder6 with ZEOS6 I used a TZReadOnlyQuery wich calls a stored procedure (MySQL): in the SQL property I have "call proc()".

In the new situation I get the error "PROCEDURE can't return a resultset in the given context"

What to do?

Thanks for help

Regards, Henk

[EgonHugeist]

hstijnen,

can you explain more detailed what's going wrong? Which detailed configurations do you use here?

best regards

[hstijnen]

The stored proc aProc in MySQL 5.1 returns a resultset (last line such as "select * from sometable").
In the SQL property of a TZReadOnlyQuery I have "call aProc(pars)". And when I call Query->Open() then the error appears.
I think it's the same problem that lelekx reports in http://sourceforge.net/projects/zeoslib/.

In the meantime I have a way around the problem by using here TSQLQeury.

[ism]

The hundredth again I say, make a project showing the error with the database dump. Quickly Possible find the error

[EgonHugeist]

hstijnen,

i'm afraid! lelekx wrote his code was almost done! So we've to compare some sources again! It would be great to know which code he has done! What happens? Any suitable debug results?

Michael