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;