USP_DATAFORMTEMPLATE_PRELOAD_BATCH2TEMPLATE
The load procedure used by the edit dataform template "Batch Template Add Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BATCHSUPPORTSCHECKINGFORDUPLICATERECORDS | bit | INOUT | Batch supports checking for duplicate records |
| @TEMPLATEPERMISSIONS | xml | INOUT | Assign batch template administrator permissions |
| @CUSTOMIZEPERMISSIONS | xml | INOUT | Assign permissions to customize batch field options |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_BATCH2TEMPLATE
(
@BATCHSUPPORTSCHECKINGFORDUPLICATERECORDS bit = null output
, @TEMPLATEPERMISSIONS xml = null output
, @CUSTOMIZEPERMISSIONS xml = null output
)
as
set @TEMPLATEPERMISSIONS =
(select
ID as SYSTEMROLEID
, NAME
, 2 as GRANTORDENY
from dbo.SYSTEMROLE
order by NAME
for xml raw('ITEM'),type,elements,root('TEMPLATEPERMISSIONS'),BINARY BASE64);
set @CUSTOMIZEPERMISSIONS =
(select
ID as SYSTEMROLEID
, NAME
, 2 as GRANTORDENY
from dbo.SYSTEMROLE
order by NAME
for xml raw('ITEM'),type,elements,root('CUSTOMIZEPERMISSIONS'),BINARY BASE64);
return 0;