Label: sql

Content with label sql in Geo SCADA Expert Software (See content from all spaces)
Related Labels: performance, linked, tables, odbc, logic, clearscada

Page: Accessing Data via SQL in Structured Text
structured text program you can define simple variables using %M, %I and %Q, however useful these are they are static. There is a more dynamic way of reading data from ClearSCADA to use in a structured text program that returns the data in the form of a "resultset ...
Other labels: clearscada, logic
Page: Logic Execution
logic engine is single threaded, this means that ClearSCADA can only run one logic program at a time. To protect logic programs from being affected by poorly written logic programs that cannot execute correctly ClearSCADA includes an instruction ...
Other labels: clearscada, logic, linked, tables, performance
Page: SQL Join Optimization
page describes in detail how the Query Processor's join optimisation algorithm works. It is intended to help people construct queries that can be optimised efficiently and won't be rejected. Knowledge of SQL, particularly joins, is assumed. Some knowledge of the mathematical concept of permutations ...
Other labels: clearscada, odbc