Update Current Price Triggers
Posted: Sat Mar 02, 2013 4:01 am
Thought I'd share a trigger I've added to the schema to help with stock price updates - finding this very useful when adding new stock based transactions.
Code: Select all
CREATE TRIGGER insert_stock_current_price AFTER INSERT ON STOCK_V1
BEGIN
-- UPDATE THE CURRENTPRICE
UPDATE STOCK_V1 SET CURRENTPRICE = new.CURRENTPRICE WHERE STOCKNAME = new.STOCKNAME ;
-- NOW CALCULATE THE VALUE
UPDATE STOCK_V1 SET VALUE = CURRENTPRICE * NUMSHARES WHERE STOCKNAME = new.STOCKNAME ;
END ;