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.

Prerequisites

DBA authority.

Context and remarks

Many.

 Set a condition or count on a breakpoint

  1. Use the SQL Anywhere 12 plug-in to connect to the database.

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

  3. Select a procedure.

  4. Click Mode » Debug.

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

Results

The conditions on the breakpoint is set.

Next

None.

Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1