USP_DATAFORMTEMPLATE_PRELOAD_ADD_COMMITMULTIPLEBATCHESPROCESS

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

Parameters

Parameter Parameter Type Mode Description
@RECORDTYPEID uniqueidentifier INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_COMMITMULTIPLEBATCHESPROCESS
(
    @RECORDTYPEID uniqueidentifier = null output
)
as
begin            
    set nocount on;

    select 
        @RECORDTYPEID = ID
    from 
        dbo.RECORDTYPE 
    where 
        upper(NAME) = 'BATCH';

    return 0;
end