UFN_DATAFORMINSTANCE_INUSEBYBATCH
Returns a flag indicating whether the specified data form instance is used by a batch.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DATAFORMINSTANCEID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_DATAFORMINSTANCE_INUSEBYBATCH(@DATAFORMINSTANCEID uniqueidentifier)
returns bit
with execute as caller
as begin
declare @RETURNVALUE bit;
if exists(select ID from dbo.BATCHTEMPLATE
where BATCHTEMPLATE.ADDROWDATAFORMINSTANCEID = @DATAFORMINSTANCEID
or BATCHTEMPLATE.EDITROWDATAFORMINSTANCEID = @DATAFORMINSTANCEID
or BATCHTEMPLATE.COMMITROWADDDATAFORMINSTANCEID = @DATAFORMINSTANCEID
or BATCHTEMPLATE.COMMITROWEDITDATAFORMINSTANCEID = @DATAFORMINSTANCEID
or BATCHTEMPLATE.ROWCONTEXTVIEWDATAFORMINSTANCEID = @DATAFORMINSTANCEID
or BATCHTEMPLATE.ROWCONTEXTEDITDATAFORMINSTANCEID = @DATAFORMINSTANCEID)
begin
set @RETURNVALUE = 1;
end
else
begin
set @RETURNVALUE = 0;
end
return @RETURNVALUE;
end