USP_DATAFORMTEMPLATE_VIEW_DISBURSEMENTFORMAT

The load procedure used by the view dataform template "Disbursement Process Format View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@DESCRIPTION	nvarchar(100)	INOUT	Description
@REPORTNAME	nvarchar(100)	INOUT	Layout template
@TYPE	nvarchar(100)	INOUT	Type
@ISPRENUMBERED	tinyint	INOUT	Pre-numbered stock

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DISBURSEMENTFORMAT
(
    @ID uniqueidentifier
    ,@DATALOADED bit = 0 output
    ,@DESCRIPTION nvarchar(100) = null output
    ,@REPORTNAME nvarchar(100) = null output
    ,@TYPE nvarchar(100) = null output
    ,@ISPRENUMBERED tinyint = null output
)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows

    set @DATALOADED = 0;

    select 
        @DATALOADED = 1
        ,@DESCRIPTION = df.[DESCRIPTION]
        ,@REPORTNAME = rc.NAME
        ,@TYPE = df.[TYPE]
        ,@ISPRENUMBERED = df.[PRENUMBERED]
    from dbo.DISBURSEMENTFORMAT as df
    inner join dbo.REPORTCATALOG as rc
        on df.REPORTCATALOGID = rc.id
    where df.ID = @ID
    return 0;