Re: Recordset Returned via Stored Procedures

Home Forum Integrating PerfectForms Recordset Returned via Stored Procedures Re: Recordset Returned via Stored Procedures

#5351

pmeidinger
Participant

Hello,

For the sake of argument, let’s say my stored procedure has no input or output parameters and is just a SELECT statement:

CREATE PROCEDURE dbo.sp_GetBuildingList AS
BEGIN
SET NOCOUNT ON;

SELECT building, name
FROM dbo.buildings
ORDER BY name
END

How do I set up the Connection Action to receive the ‘building’ and ‘name’ fields from the stored procedure? I tried adding Return Parameters (screenshot here: http://i.imgur.com/ZPHZE.png) but I get an error:

ERROR

Agent SQL error

Procedure sp_GetBuildingList has no parameters and arguments were supplied.

How do I get those two rields back from my stored procedure?