CREATE TRIGGER InsertfehlerPruefung BEFORE INSERT ON Pruefung BEGIN SELECT CASE WHEN (NEW.theorie = 0 AND NOT (SELECT SUM(dauer) FROM fahrstunde WHERE fahrstunde.schueleremail = NEW.email ) >= 180) THEN RAISE(ABORT, 'not enough Fahrstundenminuten') END; END; I have this before insert on trigger here and it just doesnt wanna work. I try to insert a "schueleremail" who has less than 180 "fahrstundenminuten" and the trigger wont work and the insert is still successful. can please someone help?