Details
-
Bug
-
Resolution: Done
-
P2: Important
-
4.2.2
-
None
Description
When a stored procedure has "RETURN 0" then the resultset is not available in the QSqlQuery only the return value. However, the return value should be available independently and as the resultset.
Answer from Trolltech:
This happens because SQL Server creates a non-scrollable result set while Qt expects a scrollable result set. Do setForwardOnly(true) on the query object before executing the SQL that calls the stored procedure. The result set will now be available, but the return value will be discarded.