USP_DATAFORMTEMPLATE_ADD_COMMITMULTIPLEBATCHESPROCESS

The save procedure used by the add dataform template "Commit Multiple Batches Process Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(200)	IN	Name
@DESCRIPTION	nvarchar(1000)	IN	Description
@SELECTIONID	uniqueidentifier	IN	Selection
@CREATEOUTPUTSELECTION	bit	IN	Create output selections
@CREATEEXCEPTIONBATCHES	bit	IN	Create exception batches
@PURGEBATCHES	bit	IN	Delete batches after commit
@CREATEBATCHCONTROLREPORTS	bit	IN	Create control reports

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_COMMITMULTIPLEBATCHESPROCESS                
    (
        @ID uniqueidentifier OUTPUT,
        @CHANGEAGENTID uniqueidentifier,
        @NAME nvarchar(200),
        @DESCRIPTION nvarchar(1000) = '',
        @SELECTIONID uniqueidentifier = null,
        @CREATEOUTPUTSELECTION bit = 0,
        @CREATEEXCEPTIONBATCHES bit = 0,
        @PURGEBATCHES bit = 0,
        @CREATEBATCHCONTROLREPORTS bit = 0
    )
    as
    begin
        set nocount on;

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

        if @CHANGEAGENTID is null
            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

        begin try
            insert into dbo.BATCHESCOMMITPROCESS (ID, NAME, DESCRIPTION, SELECTIONID, CREATEOUTPUTSELECTION, CREATEEXCEPTIONBATCHES, PURGEBATCHES, CREATEBATCHCONTROLREPORTS, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                values (@ID, @NAME, @DESCRIPTION, @SELECTIONID, @CREATEOUTPUTSELECTION, @CREATEEXCEPTIONBATCHES, @PURGEBATCHES, @CREATEBATCHCONTROLREPORTS, @CHANGEAGENTID, @CHANGEAGENTID, GetDate(), GetDate());
        end try

        begin catch
            exec dbo.USP_RAISE_ERROR;
            return 1;
        end catch

        return 0;
    end