This section provides a technical reference for the SQL features supported in ClearSCADA.
Information about the conventions used in this section are described in the Notation topic. Information about the Data Types supported in SQL commands can be found in the Data Types page
The SCADA server supports four types of SQL command:
- SELECT queries returning data from one or more tables. Refer to command-query for more details.
- UPDATE commands setting new column values in a table. Refer to command-update for more details.
- INSERT commands adding new rows to a table. Refer to command-insert for more details.
- DELETE commands deleting existing rows from a table. Refer to command-delete for more details.
Contents
| Name | Description |
|---|---|
| CaseExpression | Functions selecting a value conditionally |
| Conditions | Syntax of conditions that can appear in a WHERE or HAVING clause. |
| DistanceFunctions | A function returning distance values. |
| Expressions | Syntax of scalar expressions. |
| NumericFunctions | A function returning a numeric value |
| StringFunctions | A function returning a string value |