Implementation of SQL in Geo SCADA Expert

The Geo SCADA Expert Guide to SQL online Help provides general information about SQL. This topic provides links out to other Geo SCADA Expert guides that describe specific aspects of SQL implementation within Geo SCADA Expert.

• Core Configuration Guide
  • Queries Bar—Explains about the Explorer Bar that provides access to Queries Lists.
  • Configuring Data Tables—You can use Data Tables to store the results of custom calculations that are running in Logic programs on your system, or to store the values that are returned by Mimic scripts. Data Tables are designed to be populated automatically using, Logic or SQL.
• Lists Guide
  • Queries List—Queries Lists are Lists of database values. You can display many Queries Lists in Geo SCADA Expert. You can use those Lists to monitor, control and compare various aspects of your system.
  • Custom Lists—Use of custom SQL query minimizes the loading of requests for data by only retrieving those records that are of interest, rather than all of the records in the database.
  • Querying Third Party ODBC Databases—You can use Geo SCADA Expert to query an ODBC database. This is useful as it allows Geo SCADA Expert users to view data stored in other ODBC database systems. If you have an SQL Server database, you can use Queries Lists to view the SQL Server’s data in Geo SCADA Expert.
  • Use SQL to Create a Filter for a List other than an Alarms List—You can use SQL to customize filters by defining the filter criteria as an SQL query.
• Logic Guide
  • Using an ST Program to Call an SQL Query—Describes how you can code an ST program to retrieve information from the database via an SQL Query.
  • Raw Historic Values in SQL Queries—Describes how to use SQL Queries in your Logic programs to retrieve multiple raw historic values.
• Mapping and Geographic Information Guide
  • Designing Queries for GIS Map Markers—Describes how to configure a User Query to hold a database query of Geo SCADA Expert database items that are to be displayed on maps. Each individual entry within the SQL query list translates to a Map Marker when shown on a map.
• Mimics Guide
  • Embedded Query List Animations - SQL—This describes how to use the Sql property to represents an SQL query that defines what is shown in an embedded List on a Mimic.
• QueryPad Guide
  • Welcome to the Geo SCADA Expert Guide to QueryPad—This guide describes how to use QueryPad to test and analyze your SQL queries. By examining the diagnostics information, you can see how the Query Processor (used to process SQL queries in Geo SCADA Expert) handles your query. You can then use that information to determine whether to change your query so that it works more efficiently.
• Scripting Guide
  • Query Functions—Describes the query functions available within scripts.
  • Query Properties—Describes the properties of the Query Control Object.
• Server Status Guide

  • Query Processor Status Information—The Query Processor branch of the Geo SCADA Expert Server Status Tool provides status information about the latest, largest and longest SQL query made on clients that are connected to the server on which you are working.

• System Administration Guide
  • SQL Query Configuration Settings—The Server Configuration Tool has SQL Query Configuration settings. You may need to adjust these settings if you have SQL Queries that need to be run on a regular basis.
  • Extra Table Queries —You can use the Extra Table Queries feature to create custom pick actions that provide access to specific Queries Lists.