USP_DATAFORMTEMPLATE_VIEW_NETCOMMUNITYPAGEDATA

The load procedure used by the view dataform template "NetCommunity Page Expression View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TRIGGERSDISABLED	bit	INOUT	TRIGGERSDISABLED
@SHOWUPGRADEINFO	bit	INOUT
@CMSTRANSACTIONSYNCENABLED	bit	INOUT
@EXCEPTIONDATALISTRECORDCOUNT	int	INOUT

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_NETCOMMUNITYPAGEDATA
                (
                    @DATALOADED bit = 0 output,
                    @TRIGGERSDISABLED bit = null output,
                    @SHOWUPGRADEINFO bit = null output,
                    @CMSTRANSACTIONSYNCENABLED bit = null output,
          @EXCEPTIONDATALISTRECORDCOUNT int = null output
                )
                as
                    set nocount on;
                    set @DATALOADED = 0;

                    select 
                        @DATALOADED = 1, 
                        @TRIGGERSDISABLED = case when dbo.UFN_BBNC_TRIGGERSENABLED() = 1 then 0 else 1 end;

                    select top 1
                        @SHOWUPGRADEINFO = TBUI.SHOWDONATIONANDSIGNUPUPGRADEINFO
                    from
                        dbo.BBIS_TRANSBATCHUPGRADEINFO TBUI;

                    if @SHOWUPGRADEINFO is null
                        set @SHOWUPGRADEINFO = 0;

                    select
                        @CMSTRANSACTIONSYNCENABLED = S.ENABLED
                    from
                        dbo.SCHEDULE S
                    where
                        S.ID = 'F3DC1530-CDF2-4989-BF6F-FABF0E958277';

                    if @CMSTRANSACTIONSYNCENABLED is null
                        set @CMSTRANSACTIONSYNCENABLED = 0;

          select @EXCEPTIONDATALISTRECORDCOUNT = count(*) from 
              dbo.BBNCTRANSACTIONDOWNLOADEXCEPTION tex inner join 
              dbo.Transactions t on tex.BBNCTRANID = t.ID;

          if @EXCEPTIONDATALISTRECORDCOUNT is null
            set @EXCEPTIONDATALISTRECORDCOUNT = 0;

                    return 0;