USP_DATAFORMTEMPLATE_ADD_DISBURSEMENTPROCESS_PRELOAD

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

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@NAME	nvarchar(100)	INOUT	Name
@DESCRIPTION	nvarchar(255)	INOUT	Description

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_DISBURSEMENTPROCESS_PRELOAD
(
    @CONTEXTID uniqueidentifier
  ,@NAME nvarchar(100) = null output
  ,@DESCRIPTION nvarchar(255) = null output    
)
as
    set nocount on;

    -- populate the fields that have default values that should be fetched from the database

    select 
    @NAME = T.NAME
    ,@DESCRIPTION = T.DESCRIPTION  
    from dbo.DISBURSEMENTPROCESSTEMPLATE as T
    where ID = @CONTEXTID

    return 0;