Automatically Populate a Data Table

Data Tables are designed to be populated automatically.

Use whichever supported application is suitable for populating your Data Tables with the records that they are to store.

Your Geo SCADA Expert system might, for example, include Data Tables that are configured to store the values of custom calculations that are running in Logic programs, or that store data values from third-party applications, with the Data Tables enabling operators to view the data from those applications, while logged on to Geo SCADA Expert.

If you intend populating any of your Data Tables with data from a third-party application, and that application is to transfer its data to Geo SCADA Expert using Open DataBase Connectivity (ODBC) data transfer standards, use Geo SCADA Expert's Data Access components for that data transfer (see Install Data Access Components on a Third-Party ODBC Client in the Geo SCADA Expert Guide to Client Administration).

Server Automation is a programming interface that enables external programs to interface with Geo SCADA Expert. You can use Server Automation to automatically populate Data Tables with the records that they are to store, see Server Automation.

You can use Logic and/or SQL to automatically populate Data Tables with the records that they are to store. For an example that uses a Structured Text Logic program to call an SQL query in order to populate a Data Table, see Example Configuration. For further information on using Logic, see the Geo SCADA Expert Guide to Logic. For information on the SQL commands that are supported by Geo SCADA Expert, see the SQL Guide. (Remember that if you want to include SQL queries in a Logic program, that program has to be a Structured Text program.)


Disclaimer

Geo SCADA Expert 2022