USP_DATAFORMTEMPLATE_EDIT_COAUPDATEBATCROW

The save procedure used by the edit dataform template "AddressFinder Batch Row Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@SEQUENCE	int	IN	Sequence
@STDADDRESSBLOCK	nvarchar(150)	IN	Standardized address
@STDCITY	nvarchar(50)	IN	Standardized city
@STDSTATEID	uniqueidentifier	IN	Standardized state
@STDPOSTCODE	nvarchar(12)	IN	Standardized ZIP
@STDDPC	nvarchar(8)	IN	Standardized DPC
@STDCART	nvarchar(10)	IN	Standardized CART
@STDLOT	nvarchar(5)	IN	Standardized LOT
@COAADDRESSBLOCK	nvarchar(150)	IN	Change of address
@COACITY	nvarchar(50)	IN	Change of address city
@COASTATEID	uniqueidentifier	IN	Change of address state
@COAPOSTCODE	nvarchar(12)	IN	Change of address ZIP
@COADPC	nvarchar(8)	IN	Change of address DPC
@COACART	nvarchar(10)	IN	Change of address CART
@COALOT	nvarchar(5)	IN	Change of address LOT

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_COAUPDATEBATCROW
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier,
                        @SEQUENCE int,
                        @STDADDRESSBLOCK nvarchar(150),
                        @STDCITY nvarchar(50),
                        @STDSTATEID uniqueidentifier,
                        @STDPOSTCODE nvarchar(12),
                        @STDDPC nvarchar(8),
                        @STDCART nvarchar(10),
                        @STDLOT nvarchar(5),
                        @COAADDRESSBLOCK nvarchar(150),
                        @COACITY nvarchar(50),
                        @COASTATEID uniqueidentifier,
                        @COAPOSTCODE nvarchar(12),
                        @COADPC nvarchar(8),
                        @COACART nvarchar(10),
                        @COALOT nvarchar(5)
                    )
                    as
                        set nocount on;

                        declare @CURRENTDATE datetime;
                        set @CURRENTDATE = getdate();

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

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

                        update dbo.BATCHCOAUPDATE
                        set STDADDRESSBLOCK = @STDADDRESSBLOCK,
                            STDCITY = @STDCITY,
                            STDSTATEID = @STDSTATEID,
                            STDPOSTCODE = @STDPOSTCODE,
                            STDDPC = @STDDPC,
                            STDCART = @STDCART,
                            STDLOT = @STDLOT,
                            COAADDRESSBLOCK = @COAADDRESSBLOCK,
                            COACITY = @COACITY,
                            COASTATEID = @COASTATEID,
                            COAPOSTCODE = @COAPOSTCODE,
                            COADPC = @COADPC,
                            COACART = @COACART,
                            COALOT = @COALOT,
                            SEQUENCE = @SEQUENCE,
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CURRENTDATE
                        where ID = @ID;

                        return 0;