How to get SQL stored procedure output / return code
C / C++ / MFC
1
Posts
1
Posters
0
Views
1
Watching
-
Hi I am calling one of my SQL server stored procedures using SQLExecute(). If there is a SQL syntax error, I can see it in the C++ code by checking the return code of SQLExecute() and calling SQLGetDiagRec(). If the stored procedure does not error, but outputs some warning message with a SQL PRINT statement, or RETURNs non-zero ... is there a simple way that the C++ code can detect this kind of soft failure ?
cheers, Neil