USP_RECORDOPERATION_ATTRIBUTEFORMEXTENSIONDELETE

Executes the "Attribute Form Extension: Delete" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being deleted.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the delete.

Definition

Copy



CREATE procedure dbo.USP_RECORDOPERATION_ATTRIBUTEFORMEXTENSIONDELETE(@ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier)
as
    set nocount on;

    declare @DATAFORMINSTANCECATALOGID uniqueidentifier;
    declare @DATAFORMTEMPLATECATALOGID uniqueidentifier;

    select @DATAFORMINSTANCECATALOGID = EXTENSIONDATAFORMINSTANCECATALOGID from dbo.ATTRIBUTEFORMEXTENSION where ID = @ID;
    select @DATAFORMTEMPLATECATALOGID = DATAFORMTEMPLATECATALOGID from dbo.DATAFORMINSTANCECATALOG where ID = @DATAFORMINSTANCECATALOGID;

    exec dbo.USP_ATTRIBUTEFORMEXTENSION_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;
    exec dbo.USP_DATAFORMINSTANCECATALOG_DELETEBYID_WITHCHANGEAGENTID @DATAFORMINSTANCECATALOGID, @CHANGEAGENTID;
    exec dbo.USP_DATAFORMTEMPLATECATALOG_DELETEBYID_WITHCHANGEAGENTID @DATAFORMTEMPLATECATALOGID, @CHANGEAGENTID;