You can also modify values of variables from the Locals window.
To modify a local variable:
In the debugger Source window, set a breakpoint at the following line in the selecter( ) method of the serverMain class:
String sql = "select name, home from xmp where id=?";
Step past this line in the execution.
Open the Locals window. Select the id variable, and select Local→Modify. Alternatively, you can set the cursor on the line and press Enter.
Enter a value of 2 in the text box, and click OK to confirm the new value. The id variable is set to 2 in the Locals window.
From the Source window, press F5 to complete execution of the query. In the Interactive SQL Data window, an error message displays indicating that no rows were found.