USP_DATAFORMTEMPLATE_EDITLOAD_COMMITMULTIPLEBATCHESPROCESS

The load procedure used by the edit dataform template "Commit Multiple Batches Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NAME	nvarchar(100)	INOUT	Name
@DESCRIPTION	nvarchar(1000)	INOUT	Description
@RECORDTYPEID	uniqueidentifier	INOUT
@SELECTIONID	uniqueidentifier	INOUT	Selection
@QUERYID	uniqueidentifier	INOUT	Query id
@QUERYTYPE	nvarchar(10)	INOUT	Query type
@CREATEOUTPUTSELECTION	bit	INOUT	Create output selections
@CREATEEXCEPTIONBATCHES	bit	INOUT	Create exception batches
@PURGEBATCHES	bit	INOUT	Delete batches after commit
@CREATEBATCHCONTROLREPORTS	bit	INOUT	Create control reports
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_COMMITMULTIPLEBATCHESPROCESS
(
@ID uniqueidentifier,
@DATALOADED bit = 0 output,
@NAME nvarchar(100) = null output,
@DESCRIPTION nvarchar(1000) = null output,
@RECORDTYPEID uniqueidentifier = null output,
@SELECTIONID uniqueidentifier = null output,
@QUERYID uniqueidentifier = null output,
@QUERYTYPE nvarchar(10) = null output,
@CREATEOUTPUTSELECTION bit = null output,
@CREATEEXCEPTIONBATCHES bit = null output,
@PURGEBATCHES bit = null output,
@CREATEBATCHCONTROLREPORTS bit = null output,
@TSLONG bigint = 0 output
)
as
begin
    set nocount on;

    set @DATALOADED = 0;
    set @TSLONG = 0;

    select
        @DATALOADED = 1,
        @NAME = BATCHESCOMMITPROCESS.NAME,
        @DESCRIPTION = BATCHESCOMMITPROCESS.DESCRIPTION,
        @SELECTIONID = BATCHESCOMMITPROCESS.SELECTIONID,
        @CREATEOUTPUTSELECTION = BATCHESCOMMITPROCESS.CREATEOUTPUTSELECTION,
        @CREATEEXCEPTIONBATCHES = BATCHESCOMMITPROCESS.CREATEEXCEPTIONBATCHES,
        @PURGEBATCHES = BATCHESCOMMITPROCESS.PURGEBATCHES,
        @CREATEBATCHCONTROLREPORTS = BATCHESCOMMITPROCESS.CREATEBATCHCONTROLREPORTS,
        @TSLONG = BATCHESCOMMITPROCESS.TSLONG
    from
        dbo.BATCHESCOMMITPROCESS
    where BATCHESCOMMITPROCESS.ID = @ID;

    select @RECORDTYPEID = ID from dbo.RECORDTYPE where upper(NAME) = 'BATCH';
    select @QUERYID = dbo.UFN_IDSET_GETQUERYID(@SELECTIONID);
    select @QUERYTYPE = dbo.UFN_IDSET_GETQUERYTYPE(@SELECTIONID);

    return 0;

end