ConditionBlockParentCondition_DAG_Check

Definition

Copy


            CREATE TRIGGER [dbo].[ConditionBlockParentCondition_DAG_Check]
                ON [dbo].[ConditionBlockParentCondition]
                FOR INSERT, UPDATE
            AS
                DECLARE @n int

                SELECT @n = Sum([dbo].[fnWillCreateCyclicConditionalContent](i.ConditionBlockID, i.ParentConditionID)) 
                    FROM inserted i

                IF @n > 0
                BEGIN
                    RAISERROR ('Attempt to create cyclic graph detected.', 15, 1)
                    ROLLBACK
                END