The SQL Test Tool allows you to:
The results of the query are displayed in a table:
Fernhill SCADA places a shortcut to the SQL Test Tool on the Windows Start Menu. Use this table to find the shortcut based on the Version of Windows you are using:
Windows Version | Shortcut Location |
---|---|
Windows 11 |
|
Windows 10 Windows Server 2022 Windows Server 2019 Windows Server 2016 |
|
Windows 8 Windows Server 2012 |
|
Windows 7 Windows Server 2008 |
|
To provide more convenient access to the SQL Test Tool, use one or more of these methods:
You can also start the SQL Test Tool from the Fernhill SCADA Notification Icon:
The toolbar provides quick access to these functions:
Icon | Description |
---|---|
![]() | Clear the SQL editor window |
![]() | Load the SQL editor window from a file |
![]() | Save the contents of the SQL editor window to a file |
![]() | Delete text; automatically saving the deleted text to the clipboard |
![]() | Copy the current text selection to the clipboard |
![]() | Paste text from the clipboard into the SQL editor window |
![]() | Undo the last editor action |
![]() | Redo the last editor action |
![]() | Connect the SQL Test Tool to the locally running Fernhill SCADA |
![]() | Stop execution of the current query |
![]() | Execute the current query once |
![]() | Start execution of the current query continuously |
![]() | Toggle the display of row numbers |
![]() | Display the execution plan for the current query |
Fernhill SCADA defines a number of predefined queries. The predefined queries provide a convenient shortcut to explore the Fernhill SCADA Database. To select a predefined query:
The Fernhill SCADA database contains database schema tables. Database schema tables provide metadata about the tables in the Fernhill SCADA Database. To select a schema table:
The result of an SQL SELECT statement is displayed in the output pane of the SQL Test Tool. You can use column alias strings to improve the appearance of the result. For example:
See Column Aliases in the SQL Test Tool for information on how to do this.
The bottom pane in the SQL Test Tool is a text editor. The text editor allows you to:
Once you begin typing in the SQL Editor Window, the query stops automatic execution.
When you have finished your edits, press the button to
restart automatic execution.
For the commands and shortcuts supported by the SQL text editor see Text Editor. For information about the SQL Query language supported by Fernhill SCADA see Fernhill SCADA Structured Query Language (SQL).
Syntax and other types of error are automatically highlighted using a red underline. If you position the mouse near an error, a tooltip displays the cause of the error:
Diagnosing Connection Problems
To learn how to solve problems connecting to a Fernhill SCADA Server.
To learn about the tools in Fernhill SCADA.
Column Aliases in the SQL Test Tool
To learn how column alias values can change row colors and associate a context menu with rows.
To learn about the commands and shortcuts supported by the text editor.
Fernhill SCADA Structured Query Language (SQL)
To learn about the structured query language (SQL) supported by Fernhill SCADA.
For the meaning of terms used in Fernhill SCADA.