USP_DATAFORMTEMPLATE_ADD_HOUSEHOLDMEMBERSIMPLIFIED_PRELOAD

The load procedure used by the edit dataform template "Household Member Simplified Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@GROUPID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@PRIMARYCONTACTID	uniqueidentifier	INOUT	Primary contact

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_HOUSEHOLDMEMBERSIMPLIFIED_PRELOAD
(
    @GROUPID uniqueidentifier,
    @PRIMARYCONTACTID uniqueidentifier = null output
)
as
    set nocount on;

    select                 
        @PRIMARYCONTACTID = C.ID
    from dbo.GROUPMEMBER GM
    inner join dbo.CONSTITUENT as C on GM.MEMBERID = C.ID
    where GM.GROUPID = @GROUPID and GM.ISPRIMARY = 1;

    return 0;