On Friday 02 June 2006 02:09 am, Pedro <[EMAIL PROTECTED]> thus communicated:
--> I need to create a trigger that decreases on a "stocks" table the amount
--> that have been inserted on the "tooken_from_stock" table.
-->
--> the trigger should be something like:
-->
--> CREATE TRIGGER triggerdecrea
I need to create a trigger that decreases on a "stocks" table the amount that have been inserted on the "tooken_from_stock" table.the trigger should be something like:CREATE TRIGGER triggerdecrease
BEFORE INSERT ON tooken_from_stockEXECUTE PROCEDURE decrease();then i need to create the procedure de
