USP_DATAFORMTEMPLATE_VIEW_TOTALMEMBERSUIWIDGET

The load procedure used by the view dataform template "Total Members UI Widget View Form"

Parameters

Parameter Parameter Type Mode Description
@DATALOADED bit INOUT Output parameter indicating whether or not data was actually loaded.
@TOTALMEMBERS bigint INOUT Total members

Definition

Copy


create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_TOTALMEMBERSUIWIDGET
(
    @DATALOADED bit = 0 output,
    @TOTALMEMBERS bigint = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select @DATALOADED = 1,
           @TOTALMEMBERS = dbo.UFN_MEMBERSHIP_GETTOTALACTIVEMEMBERS();

    return 0;