USP_DATAFORMTEMPLATE_ADD_RESEARCHPOINTTEMPLATECOPY_PRELOAD

The load procedure used by the edit dataform template "Prospect Research Template Copy Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@COPYID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@NAME	nvarchar(100)	INOUT	Report template name
@DESCRIPTION	nvarchar(255)	INOUT	Description
@SECTIONS	xml	INOUT	Selected sections

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_RESEARCHPOINTTEMPLATECOPY_PRELOAD (
                        @COPYID uniqueidentifier,
                        @NAME nvarchar(100) = null output,
                        @DESCRIPTION nvarchar(255) = null output,
                        @SECTIONS xml = null output
                    ) as begin

                        set nocount on;

                        select 
                          @SECTIONS = dbo.UFN_PROSPECTRESEARCHTEMPLATE_GETSECTIONS_TOITEMLISTXML(@COPYID),
                          @NAME = '',
                          @DESCRIPTION ='';

                        if @SECTIONS is null
                          raiserror('The record specified does not exist.', 13, 10);


                        return 0;
                    end