You can add conditions to breakpoints to instruct the debugger to interrupt execution at that breakpoint only when a certain condition or count is satisfied. For procedures and triggers, it must be a SQL search condition.
For example, to make a breakpoint apply to a specific connection only, set a condition on the breakpoint.
Connect to the database as a user with DBA authority.
In the left pane, double-click Procedures & Functions.
Select a procedure.
Choose Mode » Debug.
Choose Debug » Breakpoints.
Select the breakpoint you want to edit and then click Edit.
In the Condition list, click a condition. For example, to set the breakpoint so that it applies only to connections from a specific user ID, enter the following condition:
CURRENT USER='user-name' |
In this condition, user-name is the user ID for which the breakpoint is to be active.
Click OK and then click Close.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |