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:
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:
If the query fails with an exception, you will see the exception stack trace in the Exception Pane: