USP_DATAFORMTEMPLATE_ADD_PROJECT_PRELOAD

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

Parameters

Parameter	Parameter Type	Mode	Description
@ELEMENTNAME	nvarchar(100)	INOUT
@ELEMENTLENGTH	int	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PROJECT_PRELOAD
(
    @ELEMENTNAME nvarchar(100) = null output,
    @ELEMENTLENGTH integer = null output
)
as
    set nocount on;

  declare @PDACCOUNTSYSTEMID uniqueidentifier
  set @PDACCOUNTSYSTEMID = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B'

    select
        @ELEMENTNAME = DESCRIPTION,
        @ELEMENTLENGTH = (case PDACCOUNTSTRUCTURE.LENGTH when 0 then 100 else PDACCOUNTSTRUCTURE.LENGTH end) 
    from
        dbo.PDACCOUNTSTRUCTURE
    where
        ELEMENTDEFINITIONCODE = 7 and
    PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID and
    ISBASICGL = 0

    return 0;