USP_DATAFORMTEMPLATE_VIEW_AMPROIMPORT_CONSTITUENT

The load procedure used by the view dataform template "AuctionMaestro Pro Import Constituent View 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.
@MAPPINGID	int	INOUT	MAPPINGID
@LOOKUPID	nvarchar(max)	INOUT	LOOKUPID
@TITLE	nvarchar(100)	INOUT	TITLE
@FIRSTNAME	nvarchar(50)	INOUT	FIRSTNAME
@KEYNAME	nvarchar(100)	INOUT	KEYNAME
@ADDRESSBLOCK	nvarchar(150)	INOUT	ADDRESSBLOCK
@CITY	nvarchar(50)	INOUT	CITY
@POSTCODE	nvarchar(12)	INOUT	POSTCODE
@STATE	nvarchar(100)	INOUT	STATE
@COUNTRY	nvarchar(100)	INOUT	COUNTRY
@PHONE	nvarchar(100)	INOUT	PHONE
@EMAILADDRESS	nvarchar(100)	INOUT	EMAILADDRESS
@STATEID	uniqueidentifier	INOUT
@COUNTRYID	uniqueidentifier	INOUT

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_AMPROIMPORT_CONSTITUENT
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @MAPPINGID int = null output,
                    @LOOKUPID nvarchar(max) = null output,
                    @TITLE nvarchar(100) = null output,
                    @FIRSTNAME nvarchar(50) = null output,
                    @KEYNAME nvarchar(100) = null output,
                    @ADDRESSBLOCK nvarchar(150) = null output,
                    @CITY nvarchar(50) = null output,
                    @POSTCODE nvarchar(12) = null output,
                    @STATE nvarchar(100) = null output,
                    @COUNTRY nvarchar(100) = null output,
                    @PHONE nvarchar(100) = null output,
                    @EMAILADDRESS nvarchar(100) = null output,
                    @STATEID uniqueidentifier = null output,
                    @COUNTRYID uniqueidentifier = null output
                )
                as
                set nocount on;

                declare @SEQUENCEIDOFFSET int = 9999999;

                select top 1
                    @DATALOADED = 1,
                    @MAPPINGID = MAPPINGID,
                    @LOOKUPID = LOOKUPID,
                    @TITLE = TITLE,
                    @FIRSTNAME = FIRSTNAME,
                    @KEYNAME = KEYNAME,
                    @ADDRESSBLOCK = ADDRESSBLOCK,
                    @CITY = CITY,
                    @POSTCODE = POSTCODE,
                    @STATE = STATE,
                    @COUNTRY = COUNTRY,
                    @PHONE = PHONE,
                    @EMAILADDRESS = EMAILADDRESS,
                    @STATEID = STATEID,
                    @COUNTRYID = COUNTRYID
                from dbo.UFN_AMPROIMPORT_CONSTITUENTDATA(@ID)