USP_DATAFORMTEMPLATE_ADD_RELATIONSHIPMAPINSTANCE_PRELOAD

The load procedure used by the edit dataform template "Relationship Map Instance Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	nvarchar(137)	IN	Input parameter indicating the context ID for the record being added.
@CONTEXTRECORDID	nvarchar(100)	INOUT	Context record ID
@RELATIONSHIPMAPID	uniqueidentifier	INOUT
@RELATIONSHIPMAPSPECXML	xml	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_RELATIONSHIPMAPINSTANCE_PRELOAD
(
    @CONTEXTID nvarchar(137),
    @CONTEXTRECORDID nvarchar(100) = null output,
    @RELATIONSHIPMAPID uniqueidentifier = null output,
    @RELATIONSHIPMAPSPECXML xml = null output
)
as
    set nocount on;

    select 
        @RELATIONSHIPMAPID = substring(@CONTEXTID, 1, 36),
        @CONTEXTRECORDID = case when len(@CONTEXTID) > 36 then substring(@CONTEXTID, 38, len(@CONTEXTID) - 37) end,
        @RELATIONSHIPMAPSPECXML = RELATIONSHIPMAPSPECXML
    from dbo.RELATIONSHIPMAPCATALOG
    where ID = substring(@CONTEXTID, 1, 36)
        and 1 = dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED
        (
            RELATIONSHIPMAPCATALOG.RELATIONSHIPMAPSPECXML.query
                (
                    'declare namespace common="bb_appfx_commontypes";
                    /*/common:InstalledProductList'
                )
        );

    return 0;