Zeoslib Portal

Try to enumerate field names in zquerymaster SQL explicitly.

It seems to be a bug. I couldn't found out the reason of this error but I've found some way to avoid or weaken it. You may extract code that works with statement's resultset and move it in a single method. Example: procedure DoExecute; begin if Stmt.Execute('call proc();') then begin DoProcessRS(); ...

As far as I know, the reason of this trouble is not a closed connection.
It's, very likely, logical sequence of MySQL API calls breaks somewhere.

Could you give more detailed info, namely:
- stored procedure code;
- program code fragment that retrieves resultsets.

I got the same error lately. You might have forgotten to fill up property UpdateObject of your ZQuery component. If you havn't, try to place in ZUpdateSQL.SQL.Text this: ZUpdateSQL.ModifySQL.text='update k set name=:name where id=:old_id'; and do not forget to insert field 'id' in SELECT clause of y...

I can't imagin which code you would like to write using dbc level. Here is the sample of client's code that should handle multiple result sets: procedure TForm1.Button1Click(Sender: TObject); var conn: IZConnection; stmt: IZStatement; rs: IZResultSet; updateCount: integer; begin ZConnection1.Connec...

Hi Mark, I agree with you. It's not convenient to get access to multiple result sets through ZQuery component. But what about dbc level. Comments in unit ZDbcMySQLStatement.pas say: The methods <code>execute</code>, <code>getMoreResults</code>, <code>getResultSet</code>, and <code>getUpdateCount</co...

...but i still cannot find a solution regarding my problem. using CLIENT_MULTI_STATEMENTS=1 i'm able to accept multiple results. if i try while not zquery1.eof do begin ---CODE--- zquery1.next end; i only browse results included in the first resultset ... how can i browse to the second result set? ...

Hi, I'm using mysql 5.0 and the newest beta components. I tried to use a stored procedure using the tzquery.sql property. But If I have an OUT Variable in the stored procedure I get an error. Out or INOUT argument 2 for NEUER_KUNDE is not a variable. The Code of the storec Procedure is the followin...

hello i also have a similar problem. I pass this parameter show that i do not receive an error, but how do i browse through the different results? As I see, currently Zeos Lib doesn't support multiple statements for MySQL. Property CLIENT_MULTI_STATEMENTS=1 only lets you avoid errors like 'Can't Re...

to awerner:
From now you can execute SP, that return resultset.
For instance:

I had the same problem until I'd explored the sources. To get multiple resultset via stored procedure call, you should pass parameter CLIENT_MULTI_STATEMENTS to connection. To do this, add string 'CLIENT_MULTI_STATEMENTS=1' to property ZConnection1.Properties. Note that the string doesn't contain sp...