UFN_VALIDDEFAULTFORM

Returns the number of default forms for event

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN
@FORMCATEGORYCODE	tinyint	IN

Definition

Copy



    create function dbo.UFN_VALIDDEFAULTFORM(@EVENTID uniqueidentifier, @FORMCATEGORYCODE tinyint)
            returns int
            as
            begin
                return (select count(*) from dbo.FAFEVENTFORMTEMPLATE where ISDEFAULTFORM = 1 and EVENTID = @EVENTID and FORMCATEGORYCODE=@FORMCATEGORYCODE)
            end