USP_DATAFORMTEMPLATE_VIEW_CURRENTAPPUSERSITEREQUIRED

The load procedure used by the view dataform template "Current Application User Site Required View Form"

Parameters

Parameter Parameter Type Mode Description
@CURRENTAPPUSERID uniqueidentifier IN Input parameter indicating the ID of the current user.
@DATALOADED bit INOUT Output parameter indicating whether or not data was actually loaded.
@SITEREQUIRED bit INOUT Site required

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CURRENTAPPUSERSITEREQUIRED
                (
                    @CURRENTAPPUSERID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @SITEREQUIRED bit = null output
                )
                as
                    set nocount on

                    set @DATALOADED = 1
                    set @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID)

                    return 0