/* 16.12.2025 2 Системни настройки */ SET TERM ^ ; CREATE OR ALTER TRIGGER TR_SALE_INV_PREVIEW FOR SALE ACTIVE BEFORE UPDATE POSITION 0 AS DECLARE VARIABLE exists_table INT; BEGIN IF ((old.INVOICE_NO IS NOT NULL) AND (new.INVOICE_NO IS NULL)) THEN BEGIN SELECT COUNT(*) FROM RDB$RELATIONS WHERE RDB$RELATION_NAME = 'SALE_INVOICE_PREVIEW' INTO :exists_table; IF (exists_table = 1) THEN BEGIN EXECUTE STATEMENT 'DELETE FROM SALE_INVOICE_PREVIEW WHERE ID = ' || old.ID; END END END ^ SET TERM ; ^