USP_ATTRIBUTEFORMEXTENSION_EDIT

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@TABCAPTION	nvarchar(50)	IN
@EXTENDEDDATAFORMINSTANCECATALOGID	uniqueidentifier	IN
@EXTENSIONDATAFORMINSTANCECATALOGID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_ATTRIBUTEFORMEXTENSION_EDIT
(
  @ID uniqueidentifier,
  @TABCAPTION nvarchar(50),
  @EXTENDEDDATAFORMINSTANCECATALOGID uniqueidentifier,
    @EXTENSIONDATAFORMINSTANCECATALOGID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as
  declare @ORIGINALDATAFORMINSTANCECATALOGID uniqueidentifier;
  declare @ORIGINALDATAFORMTEMPLATECATALOGID uniqueidentifier;

  select @ORIGINALDATAFORMINSTANCECATALOGID = ATTRIBUTEFORMEXTENSION.EXTENSIONDATAFORMINSTANCECATALOGID,
  @ORIGINALDATAFORMTEMPLATECATALOGID = DATAFORMINSTANCECATALOG.DATAFORMTEMPLATECATALOGID
  from dbo.ATTRIBUTEFORMEXTENSION
  inner join dbo.DATAFORMINSTANCECATALOG on ATTRIBUTEFORMEXTENSION.EXTENSIONDATAFORMINSTANCECATALOGID = DATAFORMINSTANCECATALOG.ID
  where ATTRIBUTEFORMEXTENSION.ID = @ID;

  update dbo.ATTRIBUTEFORMEXTENSION
  set
    TABCAPTION = @TABCAPTION,
    EXTENDEDDATAFORMINSTANCECATALOGID = @EXTENDEDDATAFORMINSTANCECATALOGID,
    EXTENSIONDATAFORMINSTANCECATALOGID = @EXTENSIONDATAFORMINSTANCECATALOGID,
    CHANGEDBYID = @CHANGEAGENTID,
    DATECHANGED = getdate()
  where ID = @ID;

  exec dbo.USP_DATAFORMINSTANCECATALOG_DELETEBYID_WITHCHANGEAGENTID @ORIGINALDATAFORMINSTANCECATALOGID, @CHANGEAGENTID;
    exec dbo.USP_DATAFORMTEMPLATECATALOG_DELETEBYID_WITHCHANGEAGENTID @ORIGINALDATAFORMTEMPLATECATALOGID, @CHANGEAGENTID;