How Do I Use the SQL Select Debugger?

This article describes how to use the SQL Select Debugger. 

The debugger is very easy to use; it will show you the results of a successful SQL query, and also the exception stack for a bad SQL query.

SQL Debugger Interface

To open the SQL Debugger dialog, select a Tag with an SQL query, and go to Windward Tools and click Debug Query > SQL Select:

Successful Query

In the upper left-hand Select Pane, chose the data source (it must already be connected), enter your query, and click "Execute". If the query is successful, you will see its results in the bottom Results Pane:

Problem Query

If the query fails with an exception, you will see the exception stack trace in the Exception Pane:

0 Comments

Add your comment

E-Mail me when someone replies to this comment