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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » The SQL Anywhere debugger » Breakpoints

 

Editing breakpoint conditions

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, the condition must be a SQL search condition.

Prerequisites

You must have the SA_DEBUG system role.

 Task
  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. Click Mode » Debug.

  3. In the left pane, double-click Procedures & Functions and select a procedure.

  4. Click Debug » Breakpoints.

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

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

  7. Click OK and then click Close.

Results

The condition is set on the breakpoint.