USP_DATAFORMTEMPLATE_VIEW_DOCUMENT

The load procedure used by the view dataform template "Document 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.
@NAME	nvarchar(100)	INOUT	Name
@DESCRIPTION	nvarchar(255)	INOUT	Description
@ISACTIVE	bit	INOUT	Status
@TYPE	nvarchar(50)	INOUT	Type
@REPORTNAME	nvarchar(100)	INOUT	Report
@PRINTERLIST	nvarchar(100)	INOUT	Printer list
@PRIORITY	nvarchar(14)	INOUT	Priority
@TYPECODE	tinyint	INOUT	Type code
@REPORTCATALOGID	uniqueidentifier	INOUT	Report catalog ID
@SVGTEMPLATE	nvarchar(max)	INOUT

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DOCUMENT
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @NAME nvarchar(100) = null output,
                    @DESCRIPTION nvarchar(255) = null output,
                    @ISACTIVE bit = null output, 
                    @TYPE nvarchar(50) = null output,
                    @REPORTNAME nvarchar(100) = null output,
                    @PRINTERLIST nvarchar(100) = null output,                    
                    @PRIORITY nvarchar(14) = null output,
                    @TYPECODE tinyint = null output,
                    @REPORTCATALOGID uniqueidentifier = null output,
                    @SVGTEMPLATE nvarchar(max) = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    select @DATALOADED = 1,    
                           @NAME=DOCUMENT.NAME,
                           @DESCRIPTION = DOCUMENT.DESCRIPTION,
                           @ISACTIVE = ISACTIVE,
                           @TYPE = DOCUMENT.TYPE,
                           @REPORTNAME = coalesce(REPORTCATALOG.NAME, ''),
                           @PRINTERLIST = coalesce(PRINTERLIST.NAME, ''),
                           @PRIORITY = cast(SEQUENCE as nvarchar(14)),
                           @TYPECODE = DOCUMENT.TYPECODE,
                           @REPORTCATALOGID = DOCUMENT.REPORTCATALOGID,
                           @SVGTEMPLATE = DOCUMENTSVGTEMPLATE.TEMPLATE
                    from dbo.DOCUMENT 
                    left outer join dbo.REPORTCATALOG 
                        on DOCUMENT.REPORTCATALOGID = REPORTCATALOG.ID
                    left outer join dbo.PRINTERLIST 
                        on DOCUMENT.PRINTERLISTID = PRINTERLIST.ID                    
                    left outer join dbo.DOCUMENTSVGTEMPLATE
                        on DOCUMENT.ID = DOCUMENTSVGTEMPLATE.ID
                    where DOCUMENT.ID = @ID

                    if @TYPECODE=0
                        set @PRIORITY='Set by program'

                    return 0;