treasuredb/schema/triggers/x_spentFromBeginning.sql

CREATE TRIGGER x_spentFromBeginning
    BEFORE INSERT ON Credit
BEGIN
    SELECT RAISE(ABORT, "credit must be initially unused")
    WHERE NEW.spent != 0;
END;
Fixed trigger sequence 2017-02-21 22:24:27 +01:00			`CREATE TRIGGER x_spentFromBeginning`
Refactorization and splitting of schema files 2017-01-19 21:44:22 +01:00			`BEFORE INSERT ON Credit`
			`BEGIN`
Changed FAIL -> ABORT trigger exceptions With FAIL, triggers choke but leave the changes in despite. We need to have the current statement undone, however. 2017-02-22 21:58:47 +01:00			`SELECT RAISE(ABORT, "credit must be initially unused")`
Refactorization and splitting of schema files 2017-01-19 21:44:22 +01:00			`WHERE NEW.spent != 0;`
			`END;`