USP_DATAFORMINSTANCE_CREATEORUPDATEDEFAULT

Create or update data form default instance

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@FORMNAME	nvarchar(60)	IN
@DESCRIPTION	nvarchar(1000)	IN
@TEMPLATEID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@SPECUINAME	nvarchar(60)	IN
@MARTKEY	nvarchar(255)	IN

Definition

Copy



CREATE procedure [dbo].[USP_DATAFORMINSTANCE_CREATEORUPDATEDEFAULT]
    @ID uniqueidentifier output, 
    @FORMNAME nvarchar(60),
    @DESCRIPTION nvarchar(1000) = '',
    @TEMPLATEID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @SPECUINAME nvarchar(60) = N'',
  @MARTKEY nvarchar(255) = null
as

set nocount on;

declare @FORMDEFXML xml;
declare @IMPLEMENTATIONTYPE smallint;

if @SPECUINAME is null
    set @SPECUINAME = N'';

select 
  @FORMDEFXML = [FORMDEFINITIONXML], 
  @IMPLEMENTATIONTYPE = [IMPLEMENTATIONTYPE] 
  from dbo.[DATAFORMTEMPLATECATALOG] 
  where [ID] = @TEMPLATEID;

if @IMPLEMENTATIONTYPE = 0
    exec dbo.[USP_DATAFORMINSTANCE_CREATEORUPDATE_SP] @ID output, @FORMNAME, @DESCRIPTION, @FORMDEFXML, @TEMPLATEID, @CHANGEAGENTID, @SPECUINAME, @MARTKEY;
else
    exec dbo.[USP_DATAFORMINSTANCE_CREATEORUPDATE_CLR] @ID output, @FORMNAME, @DESCRIPTION, @FORMDEFXML, @TEMPLATEID, @CHANGEAGENTID, @SPECUINAME;

if @@error<>0 return 1;
return 0;