USP_DATAFORMTEMPLATE_EDITLOAD_MKTRECORDSOURCEFIELDMAPPINGS

The load procedure used by the edit dataform template "Record Source Field Mappings 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.
@FULLNAMEFIELD	nvarchar(255)	INOUT	Full name field
@FIRSTNAMEFIELD	nvarchar(255)	INOUT	First name field
@MIDDLENAMEFIELD	nvarchar(255)	INOUT	Middle name field
@LASTNAMEFIELD	nvarchar(255)	INOUT	Last name field
@TITLEFIELD	nvarchar(255)	INOUT	Title field
@SUFFIXFIELD	nvarchar(255)	INOUT	Suffix field
@COUNTRYFIELD	nvarchar(255)	INOUT	Country field
@ADDRESSLINE1FIELD	nvarchar(255)	INOUT	Address line 1 field
@ADDRESSLINE2FIELD	nvarchar(255)	INOUT	Address line 2 field
@CITYFIELD	nvarchar(255)	INOUT	City field
@STATEFIELD	nvarchar(255)	INOUT	State field
@POSTCODEFIELD	nvarchar(255)	INOUT	Post code field
@CARTFIELD	nvarchar(255)	INOUT	Carrier route field
@DPCFIELD	nvarchar(255)	INOUT	DPC field
@LOTFIELD	nvarchar(255)	INOUT	Lot number field
@PHONENUMBERFIELD	nvarchar(255)	INOUT	Phone number field
@EMAILADDRESSFIELD	nvarchar(255)	INOUT	Email address field
@FIRSTGIFTDATEFIELD	nvarchar(255)	INOUT	First gift date field
@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.

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_MKTRECORDSOURCEFIELDMAPPINGS]
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @FULLNAMEFIELD nvarchar(255) = null output,
  @FIRSTNAMEFIELD nvarchar(255) = null output,
  @MIDDLENAMEFIELD nvarchar(255) = null output,
  @LASTNAMEFIELD nvarchar(255) = null output,
  @TITLEFIELD nvarchar(255) = null output,
  @SUFFIXFIELD nvarchar(255) = null output,
  @COUNTRYFIELD nvarchar(255) = null output,
  @ADDRESSLINE1FIELD nvarchar(255) = null output,
  @ADDRESSLINE2FIELD nvarchar(255) = null output,
  @CITYFIELD nvarchar(255) = null output,
  @STATEFIELD nvarchar(255) = null output,
  @POSTCODEFIELD nvarchar(255) = null output,
  @CARTFIELD nvarchar(255) = null output,
  @DPCFIELD nvarchar(255) = null output,
  @LOTFIELD nvarchar(255) = null output,
  @PHONENUMBERFIELD nvarchar(255) = null output,
  @EMAILADDRESSFIELD nvarchar(255) = null output,
  @FIRSTGIFTDATEFIELD nvarchar(255) = null output,
  @TSLONG bigint = 0 output
)
as
  set nocount on;

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

  select
    @DATALOADED = 1,
    @FULLNAMEFIELD = [FULLNAMEFIELD],
    @FIRSTNAMEFIELD = [FIRSTNAMEFIELD],
    @MIDDLENAMEFIELD = [MIDDLENAMEFIELD],
    @LASTNAMEFIELD = [LASTNAMEFIELD],
    @TITLEFIELD = [TITLEFIELD],
    @SUFFIXFIELD = [SUFFIXFIELD],
    @COUNTRYFIELD = [COUNTRYFIELD],
    @ADDRESSLINE1FIELD = [ADDRESSLINE1FIELD],
    @ADDRESSLINE2FIELD = [ADDRESSLINE2FIELD],
    @CITYFIELD = [CITYFIELD],
    @STATEFIELD = [STATEFIELD],
    @POSTCODEFIELD = [POSTCODEFIELD],
    @CARTFIELD = [CARTFIELD],
    @DPCFIELD = [DPCFIELD],
    @LOTFIELD = [LOTFIELD],
    @PHONENUMBERFIELD = [PHONENUMBERFIELD],
    @EMAILADDRESSFIELD = [EMAILADDRESSFIELD],
    @FIRSTGIFTDATEFIELD = [FIRSTGIFTDATEFIELD],
    @TSLONG = [TSLONG]
  from dbo.[MKTRECORDSOURCEFIELDMAPPINGS]
  where [ID] = @ID;

  -- TODO:
  -- Always set this to true because we will create it during save if it doesn't exist
  set @DATALOADED = 1;

  return 0;