How do I Watch a variable when debugging a trigger?

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
mbetsill
Posts: 1
Joined: Fri 15 Nov 2019 20:26

How do I Watch a variable when debugging a trigger?

Post by mbetsill » Fri 15 Nov 2019 20:49

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

alexa
Devart Team
Posts: 2882
Joined: Fri 24 Jun 2011 14:17

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

Post by alexa » Mon 18 Nov 2019 11:08

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

Post Reply