UFN_DATAFORMINSTANCE_GETDEFAULTINSTANCEID
Returns the default dataforminstance id of the template for a given dataforminstance.
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DATAFORMINSTANCECATALOGID | uniqueidentifier | IN |
Definition
Copy
create function [dbo].[UFN_DATAFORMINSTANCE_GETDEFAULTINSTANCEID](@DATAFORMINSTANCECATALOGID uniqueidentifier) returns uniqueidentifier
as
begin
declare @mode tinyint;
declare @specxml xml;
declare @dataforminstanceid uniqueidentifier;
declare @dataformtemplateid uniqueidentifier;
select @dataformtemplateid = DATAFORMTEMPLATECATALOGID from dbo.DATAFORMINSTANCECATALOG where ID = @DATAFORMINSTANCECATALOGID;
select @dataforminstanceid = dbo.UFN_DATAFORMTEMPLATE_GETDEFAULTINSTANCEID(@dataformtemplateid);
return @dataforminstanceid
end