USP_DATAFORMTEMPLATE_ADD_GROUPMEMBERROLE_PRELOAD

The load procedure used by the edit dataform template "Group Member Role Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@GROUPMEMBERID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@MEMBERNAME	nvarchar(700)	INOUT	Member

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_GROUPMEMBERROLE_PRELOAD
(
    @GROUPMEMBERID uniqueidentifier,
    @MEMBERNAME nvarchar(700) = null output
)
as

    select                 
        @MEMBERNAME = NF.NAME
    from dbo.GROUPMEMBER
        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(GROUPMEMBER.MEMBERID) NF
    where GROUPMEMBER.ID = @GROUPMEMBERID;

    return 0;