602SQL Documentation Index  

Debug Control

The debug process can be accessed using the Debug submenu from the pop-up menu in the editor, buttons on the toolbar or keyboard shortcuts. The debug state is displayed in the toolbar to the right (Break = The debugged procedure is stopped, Running = The debug procedure is running and can be suspended using the Break action, Waiting - The debug process is waiting for the execution of the debug procedure).

Two auxiliary windows are available in the debug mode of the developer interface (Call Stack and Watch List).


Toggle breakpoint (only from the pop-up menu) - Insert or delete a breakpoint on the cursor position. A click on the left edge (gutter) of the editor window on a program line is the equivalent to this. The line with a breakpoint is marked with a red dot. Breakpoints can be toggled in the editor before the debug mode is executed. Insert breakpoints on commands that actually do something. If you try to insert a breakpoint on an unsuitable line, it will automatically be placed on the next suitable line. If you want to trace the entire procedure, insert a breakpoint on the first BEGIN statement. If the procedure is executed directly from the client in debug mode, it will stop on the first line automatically.

Continue (from the Debug menu) - The debug procedure runs to the end or to the first breakpoint (keyboard shortcut F5).

Step Over - Executes the procedure line that is marked. If the line executes another procedure (handle, trigger), the commands will be executed, but the debugger will not stop on those commands (keyboard shortcut F10).

Step Into - Executes the procedure line that is marked. If the line executes another procedure (handle, trigger), the debugger will stop on the first line of this procedure (keyboard shortcut F11).

Goto - The program will run from the line the debugger is currently on and stop at the line where the cursor is set.

Return from Current Routine - Runs the subprocedure (routine called from the debugged procedure) and stops on the first line after this procedure was called.

Break - Breaks the execution of a long process or infinite loop in the debugged procedure.

Continue Without Debugging - Stops the debug process and continues running the procedure regardless of any breakpoints.

Kill the Debugger - Terminates the debug process and execution of the debugged client. A transaction rollback is executed and data modification is recalled.

Watch - Opens a window to monitor/change a variable or expression value. Set the new value in the Expression or variable field and click the Set value button. There is a faster and easier way of displaying variables or expressions. The value is displayed as a tooltip if you place the cursor in the editor over a variable or expression.

Watch <expression> (only from the pop-up menu) - Adds a new entry into the Watch list window.