multiple query from procedure

[Demenkov Nikolay]

Hello. I have procedure witch result is like:

select name, user, type;

select surname, office, type;

select login, city, type;

‌

I’l make

‌

zdb::ResultSet QueryResult = prep.executeQuery();

‌

and when I get result by

‌

‌

while (QueryResult.next())

‌

i get only first select (name, user, type), please help, how to get multiple query? I don’t find any information about it.

[Tildeslash]

Only one Result Set can be returned and handled by executeQuery (see documentation). Use the union operator to combine the selects

[Demenkov Nikolay]

Thanks for answer, union is not good idea - row name is different

[Tildeslash]

This is not really a libzdb issue. Please investigate SQL to find a solution! F.ex. explicate name columns in the select statement, or write SQL directly in executeQuery