Recordset Returned via Stored Procedures

Home Forum Integrating PerfectForms Recordset Returned via Stored Procedures

This topic contains 3 replies, has 0 voices, and was last updated by  Anonymous 8 years, 4 months ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #451

    Anonymous

    Hello,

    Can PF support returning a recordset result set from a stored procedure call call?

    Thanks

    #5179

    ijobling
    Participant
    #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?

    #5352

    pmeidinger
    Participant

    Support helped me figure it out. In the Return Parameters, for the Stored Procedure Parameter Name, I needed to enter RS1.[columnname] to get the data back.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.