USP_DATAFORMTEMPLATE_PRELOAD_ADD_PLEDGEBYCONSTITUENT

The load procedure used by the edit dataform template "Pledge Add By Constituent Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CONSTITUENTNAME	nvarchar(255)	INOUT
@GIVENANONYMOUSLY	bit	INOUT	Pledge is anonymous
@SINGLEDESIGNATIONID	uniqueidentifier	INOUT	Designation
@SHOWACCOUNTSYSTEM	bit	INOUT
@PDACCOUNTSYSTEMID	uniqueidentifier	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_PLEDGEBYCONSTITUENT
(                                        
  @CONSTITUENTID uniqueidentifier,
  @CONSTITUENTNAME nvarchar(255) = null output,
  @GIVENANONYMOUSLY bit = null output,
  @SINGLEDESIGNATIONID uniqueidentifier = null output,
  @SHOWACCOUNTSYSTEM bit = null output,
  @PDACCOUNTSYSTEMID uniqueidentifier = null output

)
as
set nocount on;

  select 
    @CONSTITUENTNAME = NAME,
    @GIVENANONYMOUSLY = GIVESANONYMOUSLY
  from dbo.CONSTITUENT 
  where ID = @CONSTITUENTID;

            --set @SHOWACCOUNTSYSTEM = 0

            --set @PDACCOUNTSYSTEMID = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B'


return 0;