|
|
The SQL debugger works for Sybase ASE, SQL Anywhere and Oracle database connections.
To start the debug process, first find the stored procedure or function in the object
browser that you want to debug. Right click on it and select the debug option:
A parameter window will appear. Enter an appropriate value for each parameter. These
values will be used to create the execute statement for the procedure or function.
If there are no parameters, the window will indicate this. Once everything is entered,
click the debug button (the first toolbar button).
A new debug window will display. The first tab will show the SQL that will execute
the procedure or function. You can modify the contents of this window. A second
tab will display the DDL for the object you're debugging. This tab is read only
and can not be modified.
Breakpoints can not be set in SQL tab, only the tabs containing DDL for objects.
You can refresh the contents of the object tabs by clicking the refresh button (second
last tab). Toggle a breakpoint by clicking on the Toggle Breakpoint button (forth
last toolbar button). If you want to set a breakpoint in an object that is called
by your stored procedure or function, you can right click on the object in the editor
and select the Go To Definition option. A new tab will display that objects DDL.
To start the debug process, click on the first toolbar button. Click on the second
toolbar button to stop it. Use the Continue, Step Over, Step In and Step Out toolbar
buttons to navigate through your code.
Variables and their values are displayed in the Variables window. You can see the
value of a variable by hovering over it in the editor.
The Call Stack window will display the all the objects in the current call stack.
You can see which objects are calling which and what line the debugger is currently
on.
You can step into Triggers if an Insert, Update or Delete is being performed on
a table that have a trigger attached to it. This is the only way to debug triggers.
To execute SQL while the debugger is running, click on the Run SQL tab at the bottom
of the window. Enter the SQL you would like to run then click the Execute Ad hoc
SQL toolbar button. If you're running a SELECT (e.g. selecting from a temp table),
you will see the results in the result tab. If there was an error, you will see
a generic error message in the messages tab.
|
|
QweryBuilder is an SQL Editor and Query Tool. Its purpose is
to make accessing information from a database simple, quick, accurate and
efficient.
Work with your SQL Server, ASE, SQL Anywhere and Oracle databases in
one single application.
|
"I would like to say again how much time your product saves me and how I truly appreciate the responsiveness of the support you provide."
Read More Testimonials
|
|
|
