Skip navigation links

MySQL Forums :: Triggers :: Simple Trigger


Advanced Search

Re: Simple Trigger
Posted by: Peter Brawley ()
Date: May 14, 2012 05:18PM

Looks like an ordinary debugging problem. You're the only one who has the tables, so you're the only one who can debug it. The easiest way to do that is to add stubs to your Trigger, for example create a debug table(info text) and to the Trigger add a line to each logical fork inserting msg.info describing the current values &c.

If you want us to debug the Trigger, you will have to post the results of SHOW CREATE TABLE for each table involved, and post enough INSERT statements to reproduce the problem you describe.

(Note: so I could read your code, I edited your post to add CODE tags to preserve indenting. Look up BBCode for how to do this for yourself.)

PB

Options: ReplyQuote


Subject Views Written By Posted
Simple Trigger 876 Arman Barsamian 05/14/2012 04:15PM
Re: Simple Trigger 671 Peter Brawley 05/14/2012 05:18PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.