20011

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

Answer 06/28/2019 Developer FAQ 4

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.

Similar

Exception Using PayPal-PHP-SDK [Http response code 400]

hooking another program's calls to winapi functions in vb.net

CodeIgniter - MySQL Error 1064 (Update table1 inner join table2(…))

What should keep into this design approach

Using javascript to get server information

get day of the week from yyyy-mm-dd

fail to update jdk1.7.0_45 in raspberry pi

How to define multiple locations Using Google Maps API to drop pin for every post in a list of posts

Zendframework CSS Problem

How to install pdflib on WAMP Server

Authentication with selenium (Python)

The post method not posting all data from the html form

Accessing nested associative array using array_keys (PHP)

uikit 3 catch events

optaplanner: how to enforce planning variables values to be used only once

How to give a refresh equal to Ctrl+ R in gwt web app?

can't change the button color when not selected

Drools 7, event listener to whenever a rule is activated (even if partially matched)

Creating a Password when installing an android apps

What is wrong passing a 2D array to a respective pointer argument?

Javascript - [Why?] Assigning a variable to an object [duplicate]

Goback Developer FAQ 4

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)

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

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.

Similar

Goback Developer FAQ 4

Recommend

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.