USP_ATTRIBUTEFORMEXTENSION_ADD

Adds an attribute form extension to the database.

Parameters

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

Definition

Copy



create procedure dbo.USP_ATTRIBUTEFORMEXTENSION_ADD(@ID uniqueidentifier = null output,
    @TABCAPTION nvarchar(50),
    @EXTENDEDDATAFORMINSTANCECATALOGID uniqueidentifier,
    @EXTENSIONDATAFORMINSTANCECATALOGID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier)
as
    set nocount on;

    if @ID is null
        set @ID = newid();

    insert into dbo.ATTRIBUTEFORMEXTENSION (ID,
        TABCAPTION,
        EXTENDEDDATAFORMINSTANCECATALOGID,
        EXTENSIONDATAFORMINSTANCECATALOGID,
        ADDEDBYID,
        CHANGEDBYID,
        DATEADDED,
        DATECHANGED)
    values (@ID,
        @TABCAPTION,
        @EXTENDEDDATAFORMINSTANCECATALOGID,
        @EXTENSIONDATAFORMINSTANCECATALOGID,
        @CHANGEAGENTID,
        @CHANGEAGENTID,
        getdate(),
        getdate());