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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Debugging Procedures, Functions, Triggers, and Events » Working with breakpoints

Disabling and enabling breakpoints Next Page

Editing 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. From the Debug menu, choose Breakpoints.

    The Breakpoints dialog appears.

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

    The Edit Breakpoint dialog appears.

  3. Enter a condition in the Condition field.

    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.