quote:

---

Originally posted by tbits

Our problem is that we want to update a attribute based on a trigger of another table i.e. a customer orders something, it goes through a different table detailing the quantity of order, then subtracts that quantity from the warehouse stock count in the final table. Here's the trigger:

Delimiter |

Create trigger UpdateQTY before insert on invoice
FOR EACH ROW BEGIN
Update product set p_code = p_qoh - line.line_units

END
|

delimiter;


The error received is Error Code: 1235
This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

---