A breakpoint instructs the debugger to interrupt execution at a specified line. By default, a breakpoint applies to all connections.
To set a breakpoint
Connect to the database as a user with DBA authority.
In the left pane, double-click Procedures & Functions.
Select a procedure.
Choose Mode » Debug.
In the Which User Would You Like To Debug field, type * to debug all users, or type the name of the database user you want to debug.
In the right pane, click the line where you want to insert the breakpoint.
A cursor appears in the line where you clicked
A red circle appears to the left of the line of code.
To set a breakpoint (Debug menu)
Choose Debug » Breakpoints.
The Breakpoints window appears.
The New Breakpoint window appears.
In the Procedure list, select a procedure.
If required, complete the Condition and Count fields.
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.
Click OK. The breakpoint is set on the first executable statement in the procedure.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|