USP_DATAFORMTEMPLATE_VIEW_EXCHANGEDOWNLOADPROCESSPAGEEXPRESSION

The load procedure used by the view dataform template "Exchange Download Processes Page Expression View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@SETTINGSEXIST	bit	INOUT	SETTINGSEXIST
@PARAMETERSETCOUNT	int	INOUT	PARAMETERSETCOUNT

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_EXCHANGEDOWNLOADPROCESSPAGEEXPRESSION
                (
                    @DATALOADED bit = 0 output,
                    @SETTINGSEXIST bit = null output,
                    @PARAMETERSETCOUNT int = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 1;
                    set @SETTINGSEXIST = 0;

                    if exists(select ID from dbo.EXCHANGESERVER) begin
                        set @SETTINGSEXIST = 1;
                    end                    

                    select @PARAMETERSETCOUNT = count(ID) from dbo.EXCHANGEDOWNLOADPROCESS;

                    return 0;