USP_DATAFORMTEMPLATE_VIEW_MARRIAGEOPTIONS

The load procedure used by the view dataform template "Marriage Options View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@UPDATECONTACTINFO	bit	INOUT	Update contact information
@UPDATENAMEFORMATS	bit	INOUT	Update name formats
@UPDATEHOUSEHOLDRECOGNITION	bit	INOUT	Update household recognition
@SHOWMARRIAGEOPTIONS	bit	INOUT	Show marriage options
@UPDATEINDIVIDUALRELATIONSHIPS	bit	INOUT	Update individual relationships

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MARRIAGEOPTIONS
(
  @DATALOADED bit = 0 output,
  @UPDATECONTACTINFO bit = null output,
  @UPDATENAMEFORMATS bit = null output,
  @UPDATEHOUSEHOLDRECOGNITION bit = null output,
  @SHOWMARRIAGEOPTIONS bit = null output,
  @UPDATEINDIVIDUALRELATIONSHIPS bit = null output
) 

as
  set nocount on;
  set @DATALOADED = 0;

  select top 1
    @UPDATECONTACTINFO = UPDATECONTACTINFO,
    @UPDATENAMEFORMATS = UPDATENAMEFORMATS,
    @UPDATEHOUSEHOLDRECOGNITION = UPDATEHOUSEHOLDRECOGNITION,
    @UPDATEINDIVIDUALRELATIONSHIPS = UPDATEINDIVIDUALRELATIONSHIPS,
    @SHOWMARRIAGEOPTIONS = RULESSET,
    @DATALOADED = 1
  from
    dbo.UFN_MARRIAGEOPTION_GETRULES()

  return 0;