USP_DATAFORMTEMPLATE_ADD_ORGANIZATIONMERGER_PRELOAD

The load procedure used by the edit dataform template "Organization Merger Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@PRIMARYORGID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@PRIMARYORGNAME	nvarchar(154)	INOUT	Primary organization
@PRIMARYHASPARENTANDCHILDREN	bit	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_ORGANIZATIONMERGER_PRELOAD
(
    @PRIMARYORGID uniqueidentifier,
    @PRIMARYORGNAME nvarchar(154) = null output,
    @PRIMARYHASPARENTANDCHILDREN bit = null output
)
as
    set nocount on;

    -- populate the fields that have default values that should be fetched from the database
    select 
        @PRIMARYORGNAME = NAME
    from
        dbo.CONSTITUENT
    where
        ID = @PRIMARYORGID

    exec dbo.USP_DATAFORMTEMPLATE_VIEW_MERGERORGINFO @PRIMARYORGID, null, @PRIMARYHASPARENTANDCHILDREN output

    return 0;