SET TERM ^ ;CREATE TRIGGER addExpendature FOR TABLE_NAME ACTIVE AFTER INSERT AS BEGIN UPDATE TABLE_NAME SET TOTALEXPENDATURE = TOTALEXPENDATURE + new.EXPENDATURE WHERE EXPDATE > NEW.EXPDATE AND NAME=NEW.NAME;END^SET TERM ; ^
CREATE TABLE TABLE_NAME( EXPDATE DATE, NAME VARCHAR(20), EXPENDATURE INTEGER, TOTALEXPENDATURE INTEGER)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)