USP_DATAFORMTEMPLATE_VIEW_MKTMEMBERSHIPRECORDSOURCE

The load procedure used by the view dataform template "Membership Record Source 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.
@MEMBERSHIPRECORDSOURCENAME	nvarchar(255)	INOUT	Membership record source
@MEMBERSHIPSYSTEMIDFIELDNAME	nvarchar(255)	INOUT	System record ID
@MEMBERIDFIELDNAME	nvarchar(255)	INOUT	Member ID
@MEMBERFIELDNAME	nvarchar(255)	INOUT	Member name
@GIVENBYIDFIELDNAME	nvarchar(255)	INOUT	Given by ID
@GIVENBYFIELDNAME	nvarchar(255)	INOUT	Given by name
@EXPIRATIONDATEFIELDNAME	nvarchar(255)	INOUT	Expiration date
@ISGIFTFIELDNAME	nvarchar(255)	INOUT	Is gift?
@JOINDATEFIELDNAME	nvarchar(255)	INOUT	Join date
@LASTRENEWEDONDATEFIELDNAME	nvarchar(255)	INOUT	Last renewed on
@LEVELFIELDNAME	nvarchar(255)	INOUT	Level
@PROGRAMFIELDNAME	nvarchar(255)	INOUT	Program
@SENDRENEWALFIELDNAME	nvarchar(255)	INOUT	Send renewal to
@STATUSFIELDNAME	nvarchar(255)	INOUT	Status
@TERMFIELDNAME	nvarchar(255)	INOUT	Term
@TYPEFIELDNAME	nvarchar(255)	INOUT	Type
@LOOKUPIDFIELDNAME	nvarchar(255)	INOUT	Lookup ID

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTMEMBERSHIPRECORDSOURCE]
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @MEMBERSHIPRECORDSOURCENAME nvarchar(255) = null output,
  @MEMBERSHIPSYSTEMIDFIELDNAME nvarchar(255) = null output,
  @MEMBERIDFIELDNAME nvarchar(255) = null output,
  @MEMBERFIELDNAME nvarchar(255) = null output,
  @GIVENBYIDFIELDNAME nvarchar(255) = null output,
  @GIVENBYFIELDNAME nvarchar(255) = null output,
  @EXPIRATIONDATEFIELDNAME nvarchar(255) = null output,
  @ISGIFTFIELDNAME nvarchar(255) = null output,
  @JOINDATEFIELDNAME nvarchar(255) = null output,
  @LASTRENEWEDONDATEFIELDNAME nvarchar(255) = null output,
  @LEVELFIELDNAME nvarchar(255) = null output,
  @PROGRAMFIELDNAME nvarchar(255) = null output,
  @SENDRENEWALFIELDNAME nvarchar(255) = null output,
  @STATUSFIELDNAME nvarchar(255) = null output,
  @TERMFIELDNAME nvarchar(255) = null output,
  @TYPEFIELDNAME nvarchar(255) = null output,
  @LOOKUPIDFIELDNAME nvarchar(255) = null output
)
as
  set nocount on;

  set @DATALOADED = 0;

  select
    @DATALOADED = 1,
    @MEMBERSHIPRECORDSOURCENAME = [QUERYVIEWCATALOG].[DISPLAYNAME],
    @MEMBERSHIPSYSTEMIDFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTMEMBERSHIPRECORDSOURCE].[MEMBERSHIPSYSTEMIDFIELD]),
    @MEMBERIDFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTMEMBERSHIPRECORDSOURCE].[MEMBERIDFIELD]),
    @MEMBERFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTMEMBERSHIPRECORDSOURCE].[MEMBERFIELD]),
    @GIVENBYIDFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTMEMBERSHIPRECORDSOURCE].[GIVENBYIDFIELD]),
    @GIVENBYFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTMEMBERSHIPRECORDSOURCE].[GIVENBYFIELD]),
    @EXPIRATIONDATEFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTMEMBERSHIPRECORDSOURCE].[EXPIRATIONDATEFIELD]),
    @ISGIFTFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTMEMBERSHIPRECORDSOURCE].[ISGIFTFIELD]),
    @JOINDATEFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTMEMBERSHIPRECORDSOURCE].[JOINDATEFIELD]),
    @LASTRENEWEDONDATEFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTMEMBERSHIPRECORDSOURCE].[LASTRENEWEDONDATEFIELD]),
    @LEVELFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTMEMBERSHIPRECORDSOURCE].[LEVELFIELD]),
    @PROGRAMFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTMEMBERSHIPRECORDSOURCE].[PROGRAMFIELD]),
    @SENDRENEWALFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTMEMBERSHIPRECORDSOURCE].[SENDRENEWALFIELD]),
    @STATUSFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTMEMBERSHIPRECORDSOURCE].[STATUSFIELD]),
    @TERMFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTMEMBERSHIPRECORDSOURCE].[TERMFIELD]),
    @TYPEFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTMEMBERSHIPRECORDSOURCE].[TYPEFIELD]),
    @LOOKUPIDFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTMEMBERSHIPRECORDSOURCE].[LOOKUPIDFIELD])
  from 
    dbo.[MKTMEMBERSHIPRECORDSOURCE]
  inner join 
    dbo.[QUERYVIEWCATALOG] 
  on 
    [QUERYVIEWCATALOG].[ID] = [MKTMEMBERSHIPRECORDSOURCE].[QUERYVIEWCATALOGID]
  where 
    [MKTMEMBERSHIPRECORDSOURCE].[ID] = @ID;

  return 0;