Contents Index Run the method Inspect and modify variables

ASA SQL User's Guide
  Debugging Logic in the Database
    Tutorial: Getting started with the debugger
      Lesson 3: Debug a Java class

Step through source code

This section illustrates some of the ways you can step through code in the debugger.

Following the previous section, the debugger should have stopped execution of JDBCExamples.Query at the first statement in the method:

Examples 

Here are some example steps you can try:

  1. Step to the next line    Choose Debug > Step Over, or press F10 to step to the next line in the current method. Try this two or three times.

  2. Run to the cursor    Select the following line using the mouse, and choose Debug > Run To Cursor, or press Ctrl+F10 to run to that line and break:

    max_price = price;

    The yellow arrow moves to the line.

  3. Set a breakpoint and execute to it    Put the cursor at the following line (line 292) and press F9 to set a breakpoint on that line:

    return max_price;

    A red stop sign appears in the left-hand column to mark the breakpoint. Press F5 to execute to that breakpoint.

  4. Experiment    Try different methods of stepping through the code. End with F5 to complete the execution.

    The complete set of options for stepping through source code is available from the Debug menu.

    When you have completed the execution, the Interactive SQL Results pane in the Results tab displays the value 24.


Contents Index Run the method Inspect and modify variables