USP_DATAFORMTEMPLATE_EDIT_RESPONSE

This procedure provides backwards compatibility for the Response Edit Form.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@RESPONSE	nvarchar(100)	IN	Response
@ISINACTIVE	bit	IN	Inactive

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_RESPONSE]
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @RESPONSE nvarchar(100),
    @ISINACTIVE bit
)
as
    set nocount on;

    declare @CODE nvarchar(10);

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RESPONSE_2 @ID=@ID, @CODE=@CODE output;

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_RESPONSE_2
        @ID=@ID,
        @CHANGEAGENTID=@CHANGEAGENTID,
        @RESPONSE=@RESPONSE,
        @CODE=@CODE,
        @ISINACTIVE=@ISINACTIVE;

    return 0;