Home › Forum › Integrating PerfectForms › Recordset Returned via Stored Procedures › Re: Recordset Returned via Stored Procedures
July 13, 2010 at 5:30 pm #5351
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: //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?