pcsoft.us.windevCopyright 2026, PC SOFT29 Oct 2015 06:58:00 Z27 Oct 2015 19:42:00 ZHi all, I have a very simple stored procedure like this one: CREATE PROCEDURE MyProc ( -- Add the parameters for the stored procedure here @p1 int, @p2 int, @res int output ) AS BEGIN SET NOCOUNT ON; SET @res = @p1 + @p2 END GO In SQL we can call it in this way: Declare @Result INT; EXEC MyProc @p1 = 5, @p2 = 4, @Res = @Result OUTPUT;SELECT @Result And the result is, of course, 9. Now I'm trying the same with WD20, keep in mind that I have no analysis, just a connection to SQL (native access). The only way to get this running is using this: dsQuery is Data Source sQuery is string = "Declare @@Result INT; " + ... "EXEC MyProc " + EDT_Param1 + ", " + EDT_Param2 + ", @@Result OUTPUT ;" + ... "SELECT @@Result " IF HExecuteSQLQuery(dsQuery, gctMyConnection, hQueryWithoutCorrection, sQuery) THEN HReadFirst(dsQuery) Info(HRetrieveRecord(dsQuery)) ELSE Error(HErrorInfo(hErrFullDetails)) Trace(sQuery) END But I want to send the parameters of the stored procedure, I mean @p1 and @p2, like this: sQuery is string = "Declare @@Result INT; " + ... "EXEC MyProc @p1 = " + EDT_Param1 + ", @p2 = " + EDT_Param2 + ", @res = @@Result OUTPUT ;" + ... "SELECT @@Result " However this does not work and I'm getting an error. (http://screencast.com/t/R2kUfT77). Is there a way to get this working? Thanks in advance. Mauricio30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54705/read.awp29 Oct 2015 06:58:00 Z@Jorge, my sp was just an example. There are already several sp that I cannot change because the current system is working. I ju…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54705/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54705/read.awp[WD 20] MS SQL: call a stored procedure with OUTPUTguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54702/read.awp29 Oct 2015 03:26:00 Zm_conn is Connection m_conn..Provider = hOledbSQLServer m_conn..Server = "192.168.1.1" m_conn..Database = "mydb" m_conn..Use…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54702/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54702/read.awp[WD 20] MS SQL: call a stored procedure with OUTPUTguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54701/read.awp29 Oct 2015 01:53:00 ZHi Mauricio, I work for several years with WD + MS SQL and OLEDB connection. Never I used "output" in store procedure. …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54701/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54701/read.awp[WD 20] MS SQL: call a stored procedure with OUTPUTguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54699/read.awp28 Oct 2015 19:30:00 Z@Paulo, you're right. I was calling the sp like this: "MyProc" (taken from example) and it has to be like this: "MyProc @p1, @p…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54699/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54699/read.awp[WD 20] MS SQL: call a stored procedure with OUTPUTguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54697/read.awp28 Oct 2015 19:07:00 ZMaurico, As i told you before i only have WD18, i can't open your project (WD20). My code in WD18 & MSSQL 2005 to run your p…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54697/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54697/read.awp[WD 20] MS SQL: call a stored procedure with OUTPUTguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54695/read.awp28 Oct 2015 18:20:00 Z@kingdr, thanks for your suggestion but that's not the point. I know that the sp can be replace by a function in this case but t…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54695/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54695/read.awp[WD 20] MS SQL: call a stored procedure with OUTPUTguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54694/read.awp28 Oct 2015 18:17:00 Z@Paulo, it doesn't work. If you want to try, here you can download the project: https://www.dropbox.com/s/xuzp8rpwt592rje/Store…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54694/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54694/read.awp[WD 20] MS SQL: call a stored procedure with OUTPUTguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54688/read.awp28 Oct 2015 13:08:00 ZTry this: CREATE FUNCTION add2int ( @p1 int, @p2 int ) returns int AS BEGIN return @p1 + @p2 END GO // just by u…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54688/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54688/read.awp[WD 20] MS SQL: call a stored procedure with OUTPUTguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54686/read.awp28 Oct 2015 10:51:00 ZNo, I don't have any stored procedure in my analysis and it works. I'm using it in WD18 andWB18 with DB-Library, i never used…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54686/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54686/read.awp[WD 20] MS SQL: call a stored procedure with OUTPUTguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54685/read.awp28 Oct 2015 10:40:00 ZHi Paulo, I've already tried that and it didn't work. I guess that case is when you have your stored procedure defined in your …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54685/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54685/read.awp[WD 20] MS SQL: call a stored procedure with OUTPUTguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54683/read.awp28 Oct 2015 10:15:00 ZMauricio, check this help page http://doc.windev.com/en-US/?5515009https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54683/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/54670-20-sql-call-stored-procedure-with-output-54683/read.awp[WD 20] MS SQL: call a stored procedure with OUTPUT