The SQL UPDATE statement modifies one or more rows in a database table. The format of the UPDATE statement is:
update-statement ::=
UPDATE table-name
SET set-clause-list
[WHERE search-condition ]
In Fernhill SCADA, the UPDATE Statement can only be used modify these tables:
When updating a Database Table Tag, the table-name must be qualified by the schema name DatabaseTable.
It is an error if a value in the set-clause-list results in string truncation.
If you need to limit the length of a string to fit a column, use the SUBSTRING() Function.
UPDATE InternalAnalog SET Value = 2 WHERE FullName = 'Analog_01'
Fernhill SCADA .NET Framework Data Provider
To learn about the .NET Framework Data Provider for Fernhill SCADA (FernhillSoftware.Data.FernhillScadaClient).
To learn about the ODBC driver in Fernhill SCADA.
To learn about the SQL Test Tool.
For the meaning of terms used in Fernhill SCADA.