USP_DATAFORMTEMPLATE_PRELOAD_TEAMFUNDRAISINGTEAMATROOT

The load procedure used by the edit dataform template "Team Fundraising Team at Root Add Form"

Parameters

Parameter Parameter Type Mode Description
@APPEALID uniqueidentifier IN Input parameter indicating the context ID for the record being added.
@BASECURRENCYID uniqueidentifier INOUT Base currency

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_TEAMFUNDRAISINGTEAMATROOT
                    (
                        @APPEALID uniqueidentifier,
                        @BASECURRENCYID uniqueidentifier = null output
                    )
                    as 
                    set nocount on;

                    select @BASECURRENCYID = APPEAL.BASECURRENCYID
                    from dbo.APPEAL
                    where APPEAL.ID = @APPEALID;