USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTBATCHADDRESSVALIDATION

The load procedure used by the edit dataform template "Constituent Batch Address Validation Edit Data 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.
@ADDRESS_COUNTRYID	uniqueidentifier	INOUT	Country
@ADDRESS_ADDRESSBLOCK	nvarchar(150)	INOUT	Address
@ADDRESS_CITY	nvarchar(50)	INOUT	City
@ADDRESS_STATEID	uniqueidentifier	INOUT	State
@ADDRESS_POSTCODE	nvarchar(12)	INOUT	ZIP
@ADDRESS_CART	nvarchar(10)	INOUT	CART
@ADDRESS_DPC	nvarchar(8)	INOUT	DPC
@ADDRESS_LOT	nvarchar(5)	INOUT	LOT
@ADDRESS_CERTIFICATIONDATA	int	INOUT	Certification data
@ADDRESS_CONGRESSIONALDISTRICTCODEID	uniqueidentifier	INOUT	Congressional district
@ADDRESS_COUNTYCODEID	uniqueidentifier	INOUT	County
@ADDRESS_OMITFROMVALIDATION	bit	INOUT	Omit from validation
@ADDRESS_VALIDATIONMESSAGE	nvarchar(400)	INOUT

Definition

Copy


          CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTBATCHADDRESSVALIDATION
          (
            @ID uniqueidentifier,
            @DATALOADED bit = 0 output,
            @TSLONG bigint = 0 output,
            @ADDRESS_COUNTRYID uniqueidentifier = null output,
            @ADDRESS_ADDRESSBLOCK nvarchar(150) = null output,
            @ADDRESS_CITY nvarchar(50) = null output,
            @ADDRESS_STATEID uniqueidentifier = null output,
            @ADDRESS_POSTCODE nvarchar(12) = null output,
            @ADDRESS_CART nvarchar(10) = null output,
            @ADDRESS_DPC nvarchar(8) = null output,
            @ADDRESS_LOT nvarchar(5) = null output,
            @ADDRESS_CERTIFICATIONDATA int = null output,
            @ADDRESS_CONGRESSIONALDISTRICTCODEID uniqueidentifier = null output,
            @ADDRESS_COUNTYCODEID uniqueidentifier = null output,
            @ADDRESS_OMITFROMVALIDATION bit = null output,
            @ADDRESS_VALIDATIONMESSAGE nvarchar(400) = null output
          )
          as
            set nocount on;

            set @DATALOADED = 0
            set @TSLONG = 0

            select
              @DATALOADED = 1,
              @TSLONG = TSLONG,
              @ADDRESS_COUNTRYID = [ADDRESS_COUNTRYID],
              @ADDRESS_ADDRESSBLOCK = [ADDRESS_ADDRESSBLOCK],
              @ADDRESS_CITY = [ADDRESS_CITY],
              @ADDRESS_STATEID = [ADDRESS_STATEID],
              @ADDRESS_POSTCODE = [ADDRESS_POSTCODE],
              @ADDRESS_CART = [ADDRESS_CART],
              @ADDRESS_DPC = [ADDRESS_DPC],
              @ADDRESS_LOT = [ADDRESS_LOT],
              @ADDRESS_CONGRESSIONALDISTRICTCODEID = [ADDRESS_CONGRESSIONALDISTRICTCODEID], 
              @ADDRESS_CERTIFICATIONDATA = [ADDRESS_CERTIFICATIONDATA],
              @ADDRESS_COUNTYCODEID = [ADDRESS_COUNTYCODEID],
              @ADDRESS_OMITFROMVALIDATION = [ADDRESS_OMITFROMVALIDATION],
              @ADDRESS_VALIDATIONMESSAGE = [ADDRESS_VALIDATIONMESSAGE]
            from dbo.BATCHCONSTITUENT
            where ID = @ID

            return 0;