UFN_EVENT_CANSUPPORTEVENTS_NULLAPPEAL

Validates that the main event is not a team fundraising event. Main events cannot be team fundraising events.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@MAINEVENTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_EVENT_CANSUPPORTEVENTS_NULLAPPEAL
            (
                @MAINEVENTID uniqueidentifier = null
            )
            returns bit with execute as caller
            as
            begin
                if @MAINEVENTID is not null
                and (select APPEALID from dbo.EVENT where EVENT.ID = @MAINEVENTID) is not null --A team fundraising event cannot be a main event

                        return 0

                return 1
            end