USP_DATAFORMTEMPLATE_EDITLOAD_BATCHEMAILFINDERBATCHROW

The load procedure used by the edit dataform template "EmailFinder Batch Row 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.
@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.
@SEQUENCE	int	INOUT	Sequence
@EMAILFINDERID	uniqueidentifier	INOUT
@CONSTITUENTID	uniqueidentifier	INOUT	Constituent
@ADDRESSID	uniqueidentifier	INOUT
@ADDRESSBLOCK	nvarchar(150)	INOUT	Address
@CITY	nvarchar(50)	INOUT	City
@STATE	nvarchar(5)	INOUT	State
@POSTCODE	nvarchar(12)	INOUT	Zip
@EMAILADDRESS	UDT_EMAILADDRESS	INOUT	Email address
@DISPLAYEMAILADDRESS	UDT_EMAILADDRESS	INOUT	Email address
@OPTOUT	bit	INOUT	Opt out

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BATCHEMAILFINDERBATCHROW
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @SEQUENCE int = null output,
    @EMAILFINDERID uniqueidentifier = null output,
    @CONSTITUENTID uniqueidentifier = null output,
    @ADDRESSID uniqueidentifier = null output,
    @ADDRESSBLOCK nvarchar(150) = null output,
    @CITY nvarchar(50) = null output,
    @STATE nvarchar(5) = null output,
    @POSTCODE nvarchar(12) = null output,
    @EMAILADDRESS dbo.UDT_EMAILADDRESS = null output,
    @DISPLAYEMAILADDRESS dbo.UDT_EMAILADDRESS = null output,
    @OPTOUT bit = null output
)
as
    set nocount on;

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

    select
        @DATALOADED = 1,
        @TSLONG = BATCHEMAILFINDER.TSLONG,
        @SEQUENCE = BATCHEMAILFINDER.SEQUENCE,
        @EMAILFINDERID = BATCHEMAILFINDER.EMAILFINDERID,
        @CONSTITUENTID = BATCHEMAILFINDER.CONSTITUENTID,
        @ADDRESSID = BATCHEMAILFINDER.ADDRESSID,
        @ADDRESSBLOCK = ADDRESS.ADDRESSBLOCK,
        @CITY = ADDRESS.CITY,
        @STATE = STATE.ABBREVIATION,
        @POSTCODE = ADDRESS.POSTCODE,
        @EMAILADDRESS = BATCHEMAILFINDER.EMAILADDRESS,
        @DISPLAYEMAILADDRESS = case when BATCHEMAILFINDER.OPTOUT = 0 then BATCHEMAILFINDER.EMAILADDRESS else '' end,
        @OPTOUT = BATCHEMAILFINDER.OPTOUT
    from
        dbo.BATCHEMAILFINDER
    left join
        dbo.ADDRESS on ADDRESS.ID = BATCHEMAILFINDER.ADDRESSID
    left join
        dbo.STATE on STATE.ID = ADDRESS.STATEID
    where
        BATCHEMAILFINDER.ID = @ID;

    return 0;