USP_DATAFORMTEMPLATE_ADD_SELECTIONMERGE_PRELOAD

The load procedure used by the edit dataform template "Selection Merge Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@RECORDTYPEID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@GROUPS	xml	INOUT
@RECORDTYPE	nvarchar(100)	INOUT	Record type

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_SELECTIONMERGE_PRELOAD
(
    @RECORDTYPEID uniqueidentifier,
    @GROUPS xml = null output,
    @RECORDTYPE nvarchar(100) = null output
)
as
    set nocount on;

    set @GROUPS = (
        select
            NAME
        from
            dbo.UFN_SELECTION_GETGROUPNAMES(@RECORDTYPEID)
        for xml raw('ITEM'),type,elements,root('GROUPS'),binary base64
    )

  select
        @RECORDTYPE = NAME
    from
        dbo.RECORDTYPE
    where
        ID = @RECORDTYPEID;

    return 0;