20011

Does the isSelect-method of QSqlQuery return true when a stored procedure is executed?

Question:

Will the isSelect-method of QSqlQuery return true when a stored procedure containing a SELECT-statment is executed on sqlserver?

Answer1:

The documentation states that isSelect: "Returns true if the current query is a SELECT statement; otherwise returns false"

During my testing I found that it also returns true for an EXEC statement on sqlserver if there is a result-set to be fetched.

Recommend

  • How to read data faster in Qt?
  • Insert Strings that contain “ ` ” or “ ' ” to the database table - Qt
  • QTableview specify standard search field
  • Deallocation of items in QStandardItemModel
  • Database design 1 to 1 relationship
  • Is a conditional response possible with netcat
  • SQL conditional statement
  • TableView in QT5 doesn't show MYSQL Data, just empty rows are shown
  • Get Repeater data with foreach
  • Python: sqlite OR statement
  • concatenating results from SQL query and NULL columns
  • Adding max(value)+1 in new row, can this be a problem?
  • Can I combine several select queries in .net so they are returned in 1 batch?
  • Rows to Columns using Sql Query
  • Hibernate reverse engineering - mapping a table to Java enum
  • HSQLDB Statement and Java NaN doubles
  • How to escape colon (:) character while executing native SQL queries against an Informix database us
  • Meteor.. accounts- password— Create account on client without login
  • INSERT EXEC Statement cannot be nested [duplicate]
  • Thread synchronization with syncwarp
  • Get used tables from sql query [duplicate]
  • How can I run DataNucleus Bytecode Enhancer from SBT?
  • Jquery Knockout: ko.computed() vs classic function?
  • pillow imaging ImportError
  • Spring security and special characters
  • Finding past revisions of files in StarTeam w/ .NET SDK / C#
  • Java applet as stand-alone Windows application?
  • Trying to switch camera back to front but getting exception
  • ActionScript 2 vs ActionScript 3 performance
  • Display Images one by one with next and previous functionality
  • ORA-29908: missing primary invocation for ancillary operator
  • Jquery - Jquery Wysiwyg return html as a string
  • How to get next/previous record number?
  • Comma separated Values
  • SQL merge duplicate rows and join values that are different
  • Free memory of cv::Mat loaded using FileStorage API
  • How do you join a server to an Active Directory (domain)?
  • Angular 2 constructor injection vs direct access
  • How does Linux kernel interrupt the application?
  • Programmatically clearing map cache
  • Reading document lines to the user (python)