USP_DATAFORMTEMPLATE_EDITLOAD_GLOBALMARRIAGERULES

The load procedure used by the edit dataform template "Global Marriage Rules Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@SETMARITALSTATUS	bit	INOUT	Change marital status
@MARITALSTATUSCODEID	uniqueidentifier	INOUT	Marital status
@COPYPHONENUMBER	bit	INOUT
@COPYEMAILADDRESS	bit	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_GLOBALMARRIAGERULES
(
  @DATALOADED bit = 0 output,
  @SETMARITALSTATUS bit = null output,
  @MARITALSTATUSCODEID uniqueidentifier = null output,
  @COPYPHONENUMBER bit = null output,
  @COPYEMAILADDRESS bit = null output
) 
as
  set nocount on;
  set @DATALOADED = 0;

  select top 1
    @SETMARITALSTATUS = SETMARITALSTATUS,
    @MARITALSTATUSCODEID = MARITALSTATUSCODEID,
    @COPYPHONENUMBER = COPYPHONENUMBER,
    @COPYEMAILADDRESS = COPYEMAILADDRESS,
    @DATALOADED = 1
  from
    dbo.UFN_MARRIAGERULE_GETRULES()

  return 0;