USP_DATAFORMTEMPLATE_ADD_PRELOAD_DESIGNATION

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

Parameters

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

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PRELOAD_DESIGNATION
                    (
                        @DESIGNATIONID uniqueidentifier,
                        @DESIGNATIONPATH nvarchar(512) = null output,
                        @PARENTLOOKUPID nvarchar(412) = null output
                    )
                    as
                    begin
                        set nocount on;

                        select @DESIGNATIONPATH = NAME,
                            @PARENTLOOKUPID = USERID
                        from dbo.DESIGNATION 
                        where DESIGNATION.ID = @DESIGNATIONID;

                        return 0;

                    end