USP_DATAFORMTEMPLATE_VIEW_MKTRECORDSOURCEFIELDMAPPINGS
The load procedure used by the view dataform template "Record Source Field Mappings View Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | The input ID parameter used to load the fields defined on the form. |
| @FULLNAMEFIELDNAME | nvarchar(255) | INOUT | Full name |
| @FIRSTNAMEFIELDNAME | nvarchar(255) | INOUT | First name |
| @MIDDLENAMEFIELDNAME | nvarchar(255) | INOUT | Middle name |
| @LASTNAMEFIELDNAME | nvarchar(255) | INOUT | Last name |
| @ORGNAMEFIELDNAME | nvarchar(255) | INOUT | Org name |
| @TITLEFIELDNAME | nvarchar(255) | INOUT | Title |
| @SUFFIXFIELDNAME | nvarchar(255) | INOUT | Suffix |
| @COUNTRYFIELDNAME | nvarchar(255) | INOUT | Country |
| @ADDRESSLINE1FIELDNAME | nvarchar(255) | INOUT | Address line 1 |
| @ADDRESSLINE2FIELDNAME | nvarchar(255) | INOUT | Address line 2 |
| @CITYFIELDNAME | nvarchar(255) | INOUT | City |
| @STATEFIELDNAME | nvarchar(255) | INOUT | State |
| @POSTCODEFIELDNAME | nvarchar(255) | INOUT | Post code |
| @CARTFIELDNAME | nvarchar(255) | INOUT | CART |
| @DPCFIELDNAME | nvarchar(255) | INOUT | DPC |
| @LOTFIELDNAME | nvarchar(255) | INOUT | LOT |
| @PHONENUMBERFIELDNAME | nvarchar(255) | INOUT | Phone number |
| @EMAILADDRESSFIELDNAME | nvarchar(255) | INOUT | Email address |
| @FIRSTGIFTDATEFIELDNAME | nvarchar(255) | INOUT | First gift date |
| @DATALOADED | bit | INOUT | Output parameter indicating whether or not data was actually loaded. |
| @ADDRESSLINE3FIELDNAME | nvarchar(255) | INOUT | Address line 3 |
| @ADDRESSLINE4FIELDNAME | nvarchar(255) | INOUT | Address line 4 |
| @ADDRESSLINE5FIELDNAME | nvarchar(255) | INOUT | Address line 5 |
| @HOUSEHOLDIDFIELDNAME | nvarchar(255) | INOUT | Household ID |
| @HEADOFHOUSEHOLDFIELDNAME | nvarchar(255) | INOUT | Head of household |
| @DATELASTCHANGEDFIELDNAME | nvarchar(255) | INOUT | Date last changed |
| @ADDRESSEEFIELDNAME | nvarchar(255) | INOUT | Addressee |
| @SALUTATIONFIELDNAME | nvarchar(255) | INOUT | Salutation |
| @ISHOUSEHOLDFIELDNAME | nvarchar(255) | INOUT | Is household |
| @LOOKUPIDFIELDNAME | nvarchar(255) | INOUT | Lookup ID |
Definition
Copy
CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTRECORDSOURCEFIELDMAPPINGS]
(
@ID uniqueidentifier,
@FULLNAMEFIELDNAME nvarchar(255) = null output,
@FIRSTNAMEFIELDNAME nvarchar(255) = null output,
@MIDDLENAMEFIELDNAME nvarchar(255) = null output,
@LASTNAMEFIELDNAME nvarchar(255) = null output,
@ORGNAMEFIELDNAME nvarchar(255) = null output,
@TITLEFIELDNAME nvarchar(255) = null output,
@SUFFIXFIELDNAME nvarchar(255) = null output,
@COUNTRYFIELDNAME nvarchar(255) = null output,
@ADDRESSLINE1FIELDNAME nvarchar(255) = null output,
@ADDRESSLINE2FIELDNAME nvarchar(255) = null output,
@CITYFIELDNAME nvarchar(255) = null output,
@STATEFIELDNAME nvarchar(255) = null output,
@POSTCODEFIELDNAME nvarchar(255) = null output,
@CARTFIELDNAME nvarchar(255) = null output,
@DPCFIELDNAME nvarchar(255) = null output,
@LOTFIELDNAME nvarchar(255) = null output,
@PHONENUMBERFIELDNAME nvarchar(255) = null output,
@EMAILADDRESSFIELDNAME nvarchar(255) = null output,
@FIRSTGIFTDATEFIELDNAME nvarchar(255) = null output,
@DATALOADED bit = 0 output,
@ADDRESSLINE3FIELDNAME nvarchar(255) = null output,
@ADDRESSLINE4FIELDNAME nvarchar(255) = null output,
@ADDRESSLINE5FIELDNAME nvarchar(255) = null output,
@HOUSEHOLDIDFIELDNAME nvarchar(255) = null output,
@HEADOFHOUSEHOLDFIELDNAME nvarchar(255) = null output,
@DATELASTCHANGEDFIELDNAME nvarchar(255) = null output,
@ADDRESSEEFIELDNAME nvarchar(255) = null output,
@SALUTATIONFIELDNAME nvarchar(255) = null output,
@ISHOUSEHOLDFIELDNAME nvarchar(255) = null output,
@LOOKUPIDFIELDNAME nvarchar(255) = null output
)
as
set nocount on;
set @DATALOADED = 0;
select
@DATALOADED = 1,
@FULLNAMEFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [FULLNAMEFIELD]),
@FIRSTNAMEFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [FIRSTNAMEFIELD]),
@MIDDLENAMEFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [MIDDLENAMEFIELD]),
@LASTNAMEFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [LASTNAMEFIELD]),
@ORGNAMEFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [ORGNAMEFIELD]),
@TITLEFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [TITLEFIELD]),
@SUFFIXFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [SUFFIXFIELD]),
@COUNTRYFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [COUNTRYFIELD]),
@ADDRESSLINE1FIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [ADDRESSLINE1FIELD]),
@ADDRESSLINE2FIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [ADDRESSLINE2FIELD]),
@CITYFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [CITYFIELD]),
@STATEFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [STATEFIELD]),
@POSTCODEFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [POSTCODEFIELD]),
@CARTFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [CARTFIELD]),
@DPCFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [DPCFIELD]),
@LOTFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [LOTFIELD]),
@PHONENUMBERFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [PHONENUMBERFIELD]),
@EMAILADDRESSFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [EMAILADDRESSFIELD]),
@FIRSTGIFTDATEFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [FIRSTGIFTDATEFIELD]),
@ADDRESSLINE3FIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [ADDRESSLINE3FIELD]),
@ADDRESSLINE4FIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [ADDRESSLINE4FIELD]),
@ADDRESSLINE5FIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [ADDRESSLINE5FIELD]),
@HOUSEHOLDIDFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [HOUSEHOLDIDFIELD]),
@HEADOFHOUSEHOLDFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [HEADOFHOUSEHOLDFIELD]),
@DATELASTCHANGEDFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [DATELASTCHANGEDFIELD]),
@ADDRESSEEFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [ADDRESSEEFIELD]),
@SALUTATIONFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [SALUTATIONFIELD]),
@ISHOUSEHOLDFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [ISHOUSEHOLDFIELD]),
@LOOKUPIDFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([ID], [LOOKUPIDFIELD])
from dbo.[MKTRECORDSOURCEFIELDMAPPINGS]
where [ID] = @ID;
-- always return loaded as true
set @DATALOADED = 1
return 0;