Zeoslib Portal

Ok, after looking arround i think the Problem of both error messages is the same. Because of the functionality of getting more than one resultset mysql waits for a "next result" command. But i don't use more than one resultset. There must be a easy way to "close" the called store...

Hello!


No ideas?

I tried the current Version 5.1.34 with the same Problem (out of sync)!


Bye Sven!

Hello I have a Function that makes the queries and checks for error (and tries it 10 times... ) with a code like this: form1.ZQuery1.sql.clear; form1.ZQuery1.Sql.Add ('CALL ......'); form1.zquery1.open; While NOT form1.ZQuery1.Eof do BEGIN ..... END; I wondered because it works with the error in big...

Hello!

Thanks for your reply.
Yes i think also that it is a mysql lib Problem. But do you know what the reason for the "out of sync" Problem could be?
I wan't to get out if it is an library Problem, but now i have anoter Problem :-)


Bye Sven!

Hello!

Now it use a new version of libymysql.dll (but nevertheless i wan't to know how i could specify the dll) with the next bigger Problem.
The Code is the same, but now with an Error "Commands out of sync" after any query.


Bye SVen

Hello! I've two Problems.... 1. I use Stored Procedures with resultsets on mysql 5.1. All of them works fine but with one Problem. If the Resultset of the first calles Procedure is bigger than 88 Lines (in the case of this Procedure) the NEXT call will give me a "Lost Connection during query&qu...

Hmmmmm now it works but i dont't know why......

Bye Sven!

Hello! I don't know what you mean, i sent you the code a few topics upper.... CREATE DEFINER=`admin`@`%` PROCEDURE `test2`() BEGIN SELECT * FROM Gilden; END ZConnection1.Properties.Add('CLIENT_MULTI_STATEMENTS=1'); ZConnection1.Connect; ZQuery1.SQL.Clear; ZQuery1.SQL.add('set names ''utf8'';'); ZQue...

20070314 : Added Multiple resultset support on Dbc level - Code by Asis - See http://zeos.firmos.at/viewtopic.php?t=459 and http://zeos.firmos.at/viewtopic.php?t=912



did i understand something wrong?!?!?!?


Bye Sven!

mdaems wrote:Maybe you could have a look here... http://zeos.firmos.at/viewtopic.php?t=1453

Mark

No, i need a resultset as result (nice sentence).....
And i think it should works after the changes in the latest beta (test, svn or however) version!


Bye SVen!

cipto_kh wrote:What database you're working?
mmm.. I never do like that, usually I use TZStroredProcedure or TZQuery component

I am using mysql, so i cannot use TSoredProcedures!


Bye Sven!

Hello! Now i installed the latest svn Version of zeos, but i can't open stored procedures with result sets. In many topics is written, that it works with the latest svn and there was a code example, too.... but i only get the message "can't return a result set in given context" My Code: Pr...

Hello!

Is there any autoreconnect possibility in zeos?
I often have the problem that my mysql server is unaivailabe for a
few seconce and then i get an error message in the Programm.





Bye Sven Lehnert

Okay,

you mean i've to add the PRIMARY-Key in the select command even if i don't need it..... okay.... thanks!


Bye Sven!

Hallo! I have a big problem with the .edit and .post procedure. The following programcode Zquery1.SQL.Add('Select lastlogin from Benutzer where `Benutzername` = BINARY'''+AnsiToUTF8(konfig.benutzername)+''';') If NOT form1.Zquery1.eof then BEGIN form1.ZQuery1.edit; form1.Zquery1.FieldValues['lastlog...