fnFormTitleIsOK
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @FormTitle | nvarchar(200) | IN | |
| @ClientSitesID | int | IN |
Definition
Copy
CREATE FUNCTION [dbo].[fnFormTitleIsOK](@FormTitle nvarchar(200), @ClientSitesID int)
RETURNS uniqueidentifier
AS
BEGIN
RETURN (
SELECT A.[Guid]
FROM dbo.CustomFormElement A
INNER JOIN dbo.CustomFormSettings B ON A.[Guid] = B.[FormGuid]
WHERE B.[ClientSitesID] = @ClientSitesID AND A.[Title] = @FormTitle AND A.[TypeID] = 1
)
END