USP_DATAFORMTEMPLATE_VIEW_MANAGESYSTEMROLES_PAGEEXPRESSION
The load procedure used by the view dataform template "Manage System Roles Page Expression View Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DATALOADED | bit | INOUT | Output parameter indicating whether or not data was actually loaded. |
| @SECURITYGROUPS_AREDEFINED | bit | INOUT | SECURITYGROUPS_AREDEFINED |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MANAGESYSTEMROLES_PAGEEXPRESSION
@DATALOADED bit = 0 output,
@SECURITYGROUPS_AREDEFINED bit = null output
as
set nocount on;
set @DATALOADED = 0;
select
@DATALOADED = 1,
@SECURITYGROUPS_AREDEFINED =case when
(select count(*) from dbo.CONSTIT_SECURITY_ATTRIBUTE) > 0 then 1 else 0 end
return 0;