USP_DATAFORMTEMPLATE_ADD_DESIGNATIONHYBRID_PRELOAD

The load procedure used by the edit dataform template "Designation Hybrid Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@PARENTDESIGNATIONID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@PARENTDESIGNATIONPATH	nvarchar(512)	INOUT
@PARENTLOOKUPID	nvarchar(412)	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_DESIGNATIONHYBRID_PRELOAD
(
    @PARENTDESIGNATIONID uniqueidentifier,
    @PARENTDESIGNATIONPATH nvarchar(512) = null output,
    @PARENTLOOKUPID nvarchar(412) = null output
) as
begin
    set nocount on;

    -- this well known guid is passed by DesignationHierarchy.Page.xml to indicate a root level designation is being added
    if @PARENTDESIGNATIONID <> '0D47D951-8E96-4FBA-A7AA-2339B3D7B0BC'
    begin
        select
            @PARENTDESIGNATIONPATH = DESIGNATION.NAME,
            @PARENTLOOKUPID = DESIGNATION.USERID
        from
            dbo.DESIGNATION
        where
            DESIGNATION.ID = @PARENTDESIGNATIONID;
    end

    return 0;                
end