I've been working through the instructions found here: http://www.devart.com/dbforge/mysql/stu ... index.html
I have a procedure set up that runs an insert statement which causes a trigger to fire after insert.
It's all good up until step 8 in the instructions (Step through the [procedure] code using the F11 key or the Step Into button, or press Ctrl+F5 to move directly to the breakpoint. At the INSERT INTO schedule_list statement, when you press F11 again, you will step into the trigger.)
The problem is that it doesn't step into the trigger. It fires the trigger. I know it's firing because I get a javascript alert message saying "column 'my_var' cannot be null" which goes away if I comment out the body of the trigger.
I have set break points at the insert statement that fires the trigger, and also have several breakpoints in the trigger code.
Also, as soon as I click "Start Debugging", all the breakpoints in the trigger go white with a little cross icon on them, but the breakpoints in the procedure code stay full red. I don't know what this means.
Can anyone here help me out and tell me how to get the debugger to step into the trigger so I can debug it?
Thanks
