5299966837
With FAIL, triggers choke but leave the changes in despite. We need to have the current statement undone, however.
9 lines
313 B
SQL
9 lines
313 B
SQL
CREATE TRIGGER x_changedDebit
|
|
BEFORE UPDATE OF debtor, transferCredit, value ON Debit
|
|
WHEN EXISTS (SELECT * FROM Transfer WHERE billId=NEW.billId)
|
|
AND NOT EXISTS (SELECT * FROM __INTERNAL_TRIGGER_STACK LIMIT 1)
|
|
BEGIN
|
|
SELECT RAISE(ABORT, "Debt is involved in transfers to revoke at first");
|
|
END;
|
|
|