Skip to content Skip to sidebar Skip to footer

Calling Server Stored Procedure Using Binding

I am trying to call a MySQL server stored procedure using Qt. The procedure returns multiple rows of data I want to retrieve. The first snippet I tried works fine: QSqlQuery query(

Solution 1:

There are two sentences that can be found in the Qt documentation:

"MySQL 5 introduces stored procedure support at the SQL level, but no API to control IN, OUT and INOUT parameters." (from here, Thanks Mat)

"Stored procedures that uses the return statement to return values, or return multiple result sets, are not fully supported." (from here)

So obviously binding parameters in Qt/MySQL is pretty useless. See also this about batch mode.

Post a Comment for "Calling Server Stored Procedure Using Binding"