pcsoft.us.windevCopyright 2026, PC SOFT4 Aug 2020 14:47:14 Z30 Jul 2020 19:54:13 ZHi everyone, I'm having issues getting a return value from a stored procedure on MSSQL. Here's my SQL code: [code:sql] ALTER PROCEDURE [dbo].[createEmployeeShift] ( @employeeID varchar(38), @equipmentID varchar(38) ) AS DECLARE @ID uniqueidentifier = NEWID() INSERT INTO dbo.EmployeeShift VALUES(@ID,@employeeID,GETDATE(),NULL,@equipmentID) SELECT @ID AS ID [/code] When I run this stored procedure in MSSQL Management Studio, the stored procedure returns the generated ID as normal. However, when I do the same query and I do HReadFirst in WinDev, it says the data source has not been initialized. I'm kinda lost because I've had this kind of stored procedure work great before, but I can't get this one to work. Here's my WinDev code: [code:wl] sQuery is string dsData is Data Source sQuery = "EXEC dbo.createEmployeeShift '" + sEmployeeID + "', '" + sEquipmentID + "'" IF HExecuteSQLQuery(dsData,gctSQLConnection,hQueryWithoutCorrection,sQuery) THEN IF HReadFirst(dsData) THEN gsShiftID = dsData.ID EDT_ShiftStartTime = SysDateTime() END END [/code] Does anyone has an idea on why I'm unable to get the ID from the stored procedure into WinDev? Thanks in advance.30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67916-getting-returned-set-mssql-stored-procedure/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)Clages1pcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67916-getting-returned-set-mssql-stored-procedure-67922/read.awp4 Aug 2020 14:47:14 ZDo this way works fine i use MSSQLserver with windev using Native conector //// Pega Qt Usuarios Conectados no Banco d…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67916-getting-returned-set-mssql-stored-procedure-67922/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67916-getting-returned-set-mssql-stored-procedure-67922/read.awpGetting the returned set of a MSSQL stored procedurejolain.poirierpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67916-getting-returned-set-mssql-stored-procedure-67918/read.awp31 Jul 2020 16:10:44 ZThanks for the reply Andrea but unfortunately this syntax does not work in MSSQL. However I was able to make it work. :) I ha…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67916-getting-returned-set-mssql-stored-procedure-67918/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67916-getting-returned-set-mssql-stored-procedure-67918/read.awpGetting the returned set of a MSSQL stored procedureAndrea Chiadò Piatpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67916-getting-returned-set-mssql-stored-procedure-67917/read.awp31 Jul 2020 10:04:18 ZHi Dev, I never tried with MSSQL, but I use select from store procedure with FirebirdSQL and I use this query definition: sQ…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67916-getting-returned-set-mssql-stored-procedure-67917/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67916-getting-returned-set-mssql-stored-procedure-67917/read.awpGetting the returned set of a MSSQL stored procedure