CREATE TRIGGER [INSERT_SDACHAKR]
BEFORE INSERT
ON [SDACHAKR]
FOR EACH ROW
BEGIN
  SELECT CASE 
    WHEN (NEW.[DATA_SDACHI_KR] > (SELECT SROK_VIPOLNENIYA_KP FROM PLANOVA_DATA_KR WHERE  NAZVAMIEKP = NEW.NAZVAMIEKP)) 
    THEN RAISE(ABORT, 'POZDNO SDALI')     
  END;
END;

CREATE TRIGGER [CHANGE_BAL]
BEFORE UPDATE OF [BAL]
ON [SDACHAKR]
FOR EACH ROW
WHEN NEW.[BAL] > OLD.[BAL]
BEGIN
  UPDATE SDACHAKR
  SET BAL = NEW.[BAL],
  DATA_SDACHI_KR = date(); 
END;