USP_DATAFORMTEMPLATE_VIEW_DATAFORM_PAGEEXPRESSION

The load procedure used by the view dataform template "Data Form Page Expression 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(60)	INOUT	Name
@MODE	tinyint	INOUT	Mode
@TEMPLATEID	uniqueidentifier	INOUT	Template ID
@NOSECURITYREQUIRED	bit	INOUT	No security required

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DATAFORM_PAGEEXPRESSION
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @NAME nvarchar(60) = null output,
    @MODE tinyint = null output,
    @TEMPLATEID uniqueidentifier = null output,
    @NOSECURITYREQUIRED bit = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select 
        @DATALOADED = 1,
        @NAME = INSTANCE.UINAME,
        @MODE = TEMPLATE.MODE,
        @TEMPLATEID = TEMPLATE.ID,
        @NOSECURITYREQUIRED = TEMPLATE.NOSECURITYREQUIRED
    from 
        dbo.DATAFORMINSTANCECATALOG as INSTANCE 
            inner join dbo.DATAFORMTEMPLATECATALOG as TEMPLATE on INSTANCE.DATAFORMTEMPLATECATALOGID = TEMPLATE.ID
    where INSTANCE.ID = @ID

    return 0;