Uploaded image for project: 'Qt'
  1. Qt
  2. QTBUG-353

When a stored procedure has "RETURN 0" then the resultset is not available in the QSqlQuery only the return value

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: P2: Important P2: Important
    • 4.5.3
    • 4.2.2
    • SQL Support
    • None

      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.

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

            wallison Warwick Allison (closed Nokia identity) (Inactive)
            anshaw Andy Shaw (closed Nokia identity) (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                There are no open Gerrit changes