-
rob ijsselstijn
- InfoMaker
- Monday, 20 March 2023 07:36 AM UTC
We use Appeon infomaker 2019 and have a connection to a MS SQL database (tried ODBC and SNC SQL Native Client) We can make queries and reports, but when we want to call an Stored Procedure in MS SQL server (which works perfect in microsoft SQL server management studio without errors or other messages) we get the error message in the infomaker report:
"Select Error: Requested result set number 1 not found."
When I make a call to the stored procedure in Infomaker (new\object\tabular\stored procedure) and I select the procedure in the list, without manual creating an result-set, it also gives me the same error message.
I created a very simple stored-procedure only to get this working like so:
USE [SI_DEVELOP]
GO
/****** Object: StoredProcedure [dbo].[Test_string] Script Date: 16-3-2023 11:21:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[Test_string]
-- Add the parameters for the stored procedure here
@S1 varchar(100), @S2 varchar(100), @S1_2 varchar(100) OUTPUT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
-- Insert statements for procedure here
SET NOCOUNT ON
SET @S1_2 = @S1 + @S2
END
All help is welcome because I got stuck with this...
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.