Tobsan

CREATE TRIGGER RegisterCheck        BEFORE INSERT ON Registrations        REFERENCING NEW AS insertRow        FOR EACH ROW        WHEN (1=2)        BEGIN                INSERT INTO Waits(student,course,waitNo)                VALUES(insertRow.student, insertRow.course,                        (SELECT Count(*) FROM Waits WHERE course=insertRow.course)                );        END;