Page 1 of 1

How do I Watch a variable when debugging a trigger?

Posted: Fri 15 Nov 2019 20:49
by mbetsill
Newbie user here...I am using the Standard version of Studio for MySQL. I am trying to test an Update Before trigger, and have created a stored procedure with a single UPDATE statement for testing purposes. Trigger and Stored Procedure have been Compiled for Debug, breakpoints have been set, and I are working.

I would like to Watch a variable that is declared in the trigger, however, I can't figure out how to set the Watch. Selecting the variable, then rightClick brings up a menu but has no option to Set Watch.

How do I set a watch on a variable in a trigger?

Thanks in advance, Marilyn

Re: How do I Watch a variable when debugging a trigger?

Posted: Mon 18 Nov 2019 11:08
by alexa
You would need to navigate to the 'Watches' window, that will appear upon starting debugging, and specify a variable in the 'Name' column.

Please also see http://docs.devart.com/studio-for-mysql/debugging-stored-routine/debugging-stored-function.html