USP_DATAFORMTEMPLATE_EDIT_BATCH2_PROPERTIES

The save procedure used by the edit dataform template "Batch Properties Edit Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@BATCHNUMBER	nvarchar(100)	IN	Batch number
@DESCRIPTION	nvarchar(1000)	IN	Description
@OWNERID	uniqueidentifier	IN	Owner
@PROJECTEDNUMBEROFRECORDS	int	IN	Projected #
@PROJECTEDTOTALAMOUNT	money	IN	Projected amount
@AUTOSAVEONROWCHANGE	bit	IN	Enable auto save

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BATCH2_PROPERTIES
(
    @ID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @BATCHNUMBER nvarchar(100),
    @DESCRIPTION nvarchar(1000),
    @OWNERID uniqueidentifier,      
    @PROJECTEDNUMBEROFRECORDS int,
    @PROJECTEDTOTALAMOUNT money,
    @AUTOSAVEONROWCHANGE bit
)
as
begin
    set nocount on;

    declare @DISABLEADDNEWROW bit;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BATCH2_PROPERTIES
        @ID = @ID,
        @DISABLEADDNEWROW = @DISABLEADDNEWROW output;

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_BATCH2_PROPERTIES_2
        @ID,
        @CURRENTAPPUSERID,
        @CHANGEAGENTID,
        @BATCHNUMBER,
        @DESCRIPTION,
        @OWNERID,      
        @PROJECTEDNUMBEROFRECORDS,
        @PROJECTEDTOTALAMOUNT,
        @AUTOSAVEONROWCHANGE,
        @DISABLEADDNEWROW;
end