USP_DATAFORMTEMPLATE_EDIT_EXPORTPROCESS

Backwards compatibility procedure for USP_DATAFORMTEMPLATE_EDIT_EXPORTPROCESS_2

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@ADHOCQUERYID	uniqueidentifier	IN	Ad-hoc query
@SMARTQUERYINSTANCEID	uniqueidentifier	IN	Smart query instance
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(255)	IN	Name
@DESCRIPTION	nvarchar(1000)	IN	Description
@EXPORTDEFINITIONID	uniqueidentifier	IN	Export definition
@SELECTIONID	uniqueidentifier	IN	Selection

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_EXPORTPROCESS
            (
                @ID uniqueidentifier,
                @ADHOCQUERYID uniqueidentifier,
                @SMARTQUERYINSTANCEID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier,
                @NAME nvarchar(255),
                @DESCRIPTION nvarchar(1000),
                @EXPORTDEFINITIONID uniqueidentifier,
                @SELECTIONID uniqueidentifier    
            )
            as
            set nocount on;

            declare @CURRENTAPPUSERID uniqueidentifier = null;
            declare @SITEID uniqueidentifier = null;

            exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EXPORTPROCESS
                @ID = @ID,
                @SITEID = @SITEID;

            exec dbo.USP_DATAFORMTEMPLATE_EDIT_EXPORTPROCESS_2
                @ID,
                @ADHOCQUERYID,
                @SMARTQUERYINSTANCEID,
                @CHANGEAGENTID,
                @NAME,
                @DESCRIPTION,
                @EXPORTDEFINITIONID,
                @SELECTIONID,
                @CURRENTAPPUSERID,
                @SITEID;