A breakpoint instructs the debugger to interrupt execution at a specified line. By default, a breakpoint applies to all connections.
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
Press F9.
A red circle appears to the left of the line of code.
Choose Debug » Breakpoints.
Click New.
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 the 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.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |