USP_DATAFORMTEMPLATE_ADD_STEP_PRELOAD

The load procedure used by the edit dataform template "Step Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTPLANID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@FUNDRAISERID	uniqueidentifier	INOUT	Owner

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_STEP_PRELOAD (
                        @PROSPECTPLANID uniqueidentifier,
                        @FUNDRAISERID uniqueidentifier = null output
                    ) as begin
                        set nocount on;

                        select
                            @FUNDRAISERID = PP.PRIMARYMANAGERFUNDRAISERID
                        from dbo.PROSPECTPLAN PP
                        inner join dbo.CONSTITUENT C on PP.PROSPECTID = C.ID
                        where
                            PP.ID = @PROSPECTPLANID;

                        return 0;
                    end