pcsoft.us.windevCopyright 2026, PC SOFT2 Apr 2015 10:32:00 Z1 Apr 2015 09:17:00 ZHi All, When I try to call a stored procedure on an MSSQL database (v 2012) I get a weird error. Access is via OLEdb driver. Connection is: DB_Connection..Caption = "MyConnection" DB_Connection..User = DB_UserName DB_Connection..Password = DB_Password DB_Connection..Server = DB_Server DB_Connection..Database = DB_Name DB_Connection..Provider = hOledbSQLServer DB_Connection..Access = hOReadWrite The piece of code that is called to run the stored procedure: // Clear all error messages in the list previously set by this function pErrLst:ClearListForCaller(dbgInfo(dbgElement,dbgCurrentProcess)) // For testing m_SQLCommand = "EXEC spTest" // also tried "EXEC dbo.spTest" //// IF NOT HExecuteSQLQuery(m_dsResults,pCon,hQueryWithoutCorrection+hNoBind,m_SQLCommand) THEN ErrMsg:AddToList(pErrLst,soErrorMessage::EM_ERROR,"DB","Database error. Executing: "+m_SQLCommand,HErrorInfo(hErrMessage)) MyApp:LogError(pErrLst,HErrorInfo(hErrFullDetails)) bResult = False ELSE m_NumberOfRecords = HNbRec(m_dsResults) ... Tried with or without the hNoBind option, no difference. Tried with hQueryDefault and hQueryWithoutCorrection; no effect The error is: What happened? Error in the SQL code of query. Unable to initialize the query. Unexpected word: spTest Error code: 70208 Level: non-fatal error (EL_ONRETURN) WD55 error code: 208 Dump of the error of 'WD190SQL.DLL' module (19.0.60.2). Debugging information: IEWD190SQL=1.7 Module= Version=<19.0.60.2> Additional Information: EIT_LOGICALTABLENAME : When I use as the m_SQLCommand = "Select * from users" to test this, the query runs fine ! When I run the "EXEC spTest" from the SQL Mangement Studio, its runs fine ! When I use the Hxxxx commands or a Query with the same connection, this all works perfectly. What would be the problem that I cannot call a stored procedure via the EXEC ... syntax ? This must be something stupid or a little thing a forgot :confused:, on the forum I have found different posts using the same syntax to execute a stored procedure. So what could be wrong ? :hot: Thanks Danny30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51293-wb19-weird-problem-running-stored-procedure-via-hexecutesqlquery/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51293-wb19-weird-problem-running-stored-procedure-via-hexecutesqlquery-51318/read.awp2 Apr 2015 10:32:00 ZHi Danny, Thanks for the heads up! Interesting... I'll have a check... There's probably a similar reason why I passed the…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51293-wb19-weird-problem-running-stored-procedure-via-hexecutesqlquery-51318/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51293-wb19-weird-problem-running-stored-procedure-via-hexecutesqlquery-51318/read.awp[WB19] Weird problem running stored procedure via HExecuteSQLQueryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51293-wb19-weird-problem-running-stored-procedure-via-hexecutesqlquery-51299/read.awp1 Apr 2015 14:50:00 ZPeter, I tried this code in a windev Window, just to test things, This code worked. Myconnection..Caption = "MyConnection"…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51293-wb19-weird-problem-running-stored-procedure-via-hexecutesqlquery-51299/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51293-wb19-weird-problem-running-stored-procedure-via-hexecutesqlquery-51299/read.awp[WB19] Weird problem running stored procedure via HExecuteSQLQueryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51293-wb19-weird-problem-running-stored-procedure-via-hexecutesqlquery-51296/read.awp1 Apr 2015 12:47:00 ZHi Peter, Yes I am using your WXFramework, and it is great working with it ! Thanks for the tips, I have checked them: …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51293-wb19-weird-problem-running-stored-procedure-via-hexecutesqlquery-51296/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51293-wb19-weird-problem-running-stored-procedure-via-hexecutesqlquery-51296/read.awp[WB19] Weird problem running stored procedure via HExecuteSQLQueryguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51293-wb19-weird-problem-running-stored-procedure-via-hexecutesqlquery-51295/read.awp1 Apr 2015 10:43:00 ZHi Danny, I'm happy to see some of my classes and best practice concepts make it to good use... Some thoughts on your ques…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51293-wb19-weird-problem-running-stored-procedure-via-hexecutesqlquery-51295/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51293-wb19-weird-problem-running-stored-procedure-via-hexecutesqlquery-51295/read.awp[WB19] Weird problem running stored procedure via HExecuteSQLQuery