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

Details

    • Bug
    • Resolution: Done
    • P2: Important
    • 4.5.3
    • 4.2.2
    • SQL Support
    • 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.

      Attachments

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

        Activity

          People

            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

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes