Tobsan

FOR EACH ROW        BEGIN                IF( :insertRow.course IN (SELECT * FROM FullCourses) )                THEN                INSERT INTO Waits(student,course,waitNo)                VALUES(:insertRow.student, :insertRow.course,                        (SELECT Count(*) FROM Waits WHERE course=:insertRow.course)                );                ENDIF        END;