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

Working with breakpoints Next Page

Setting breakpoints

A breakpoint instructs the debugger to interrupt execution at a specified line. By default, a breakpoint applies to all connections.

To set a breakpoint
  1. With Sybase Central running in Debug mode, display the code where you want to set a breakpoint.

  2. Click the line on which you want to insert a breakpoint

    A cursor appears in the line where you clicked

  3. Press F9 to set the breakpoint.

    A red circle appears to the left of the line of code.

    You can also double-click the grey column just to the left of the line of code to insert or remove a breakpoint.

To set a breakpoint (Debug menu)
  1. With Sybase Central running in Debug mode, choose Debug > Breakpoints.

    The Breakpoints dialog appears.

  2. Click New.

    The New Breakpoint dialog appears.

  3. Choose a Procedure name from the dropdown list, and, optionally, enter values for Condition and Count.

    The Condition is a SQL expression that must evaluate to true for the breakpoint to interrupt execution. For example, you can set a breakpoint to apply to a connection made by a specified user, by entering the following condition:

    CURRENT USER = 'user-name'

    The Count is a number of times the breakpoint is hit before it stops execution. A value of 0 means that the breakpoint always stops execution.

  4. Click OK to set the breakpoint. The breakpoint is set on the first executable statement in the procedure.