Receiving multiple result sets of return value in SQL server stored procedure from Qt (QSqlQuery)

[SGaist]

I'd look at nextResult which is likely the place that is going to load data from the query made.

[alizadeh91]

@SGaist Yesss! calling it solved my problem. Thanks :)

[SGaist]

I'm not sure I'm following you on that one, can you clarify what you did ?

[JonB]

Sorry, I'm a bit late to the party. But http://doc.qt.io/qt-5/qsqlquery.html#nextResult is indeed, and always been, the way you move across multiple result sets (assuming your database supports them). Even in my non-Qt work with MS SQL Server this was how it worked there too.

[alizadeh91]

@SGaist I've just called QSQLQuery::nextResult after executing and reading dataTable. Then I was able to read another result sets.

[alizadeh91]

@JonB Yes, I was not familiar with that. Also in QSqlQuery doc, there was some disappointing states that the multiple result sets might not be supported.

[SGaist]

So in the end, did you had to modify the driver for your stored procedure ?

[alizadeh91]

@SGaist Not at all.

[SGaist]

So just looping with QSqlQuery::next got you the result of the stored procedure as expected ?

[alizadeh91]

@SGaist I did it this way for reading return params:

                 Query.nextResult();        // after reading table values
                 //Get Return Parameter
                 for (int i=0; i<CountReturnParam; i++)
                 {
                     qDebug() << QString("Returnparam %1 = %2")
                                 .arg(i).arg(Query.boundValue(i).toString());
                 }