I have a strange problem with QT handling stored procedures.
I’m trying to execute stored procedure on MS SQL using ODBC and QT
Assume that I already established connection to the database.
QSqlQueryModel model;
model.setQuery("{CALL test_proc}", m_Database );
if test_proc procedure is defined like
CREATE PROCEDURE TEST_PROC
AS
SELECT TOP 10 TITLE_ID, TITLE FROM TITLES
Everything is OK. The model receives data and I can display it in the table.
If test_proc procedure is defined like
CREATE PROCEDURE TEST_PROC
AS
SELECT TOP 10 TITLE_ID, TITLE FROM TITLES
RETURN 0
The model thinks that there is no data to receive and shows me that record set is empty.
I have tried to use the same procedures without using model but result was the same.
No matter if model is used or QSqlQuery as soon as I add RETURN 0 or any return for that matter I’ll receive no result.
Please do not suggest removing RETURN because this is a vendor stored procedure and can not be modified by me.
The procedure above is for demonstrating my point and is not representing actual data.
Thank you for you help
Bookmarks