Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Stored procedures and triggers » Debugging procedures, functions, triggers, and events » Working with breakpoints

 

Edit breakpoint conditions

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.

 To set a condition or count on a breakpoint
  1. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.

  2. In the left pane, double-click Procedures & Functions.

  3. Select a procedure.

  4. Choose Mode » Debug.

  5. Choose Debug » Breakpoints.

  6. Select the breakpoint you want to edit and then click Edit.

  7. 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.

  8. Click OK and then click Close.