UPDATE Statement

1. Fernhill SCADA
2. Help
3. Structured Query Language (SQL)
4. UPDATE Statement

UPDATE Statement

The 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 ]

Remarks

The UPDATE Statement can only be used modify these tables:

• Any column in a Database Table Tag.
• The Value column of a Data Point Tag table.

When updating a Database Table Tag, the table-name must be qualified by the schema name DatabaseTable.

Examples

1. Write a value to the Internal Analog Data Point Tag called 'Analog_01':

   UPDATE InternalAnalog 
   SET Value = 2 
   WHERE FullName = 'Analog_01'

Further Information

.NET Framework Data Provider

To learn about the .NET Framework Data Provider in Fernhill SCADA (FernhillSoftware.Data.FernhillScadaClient).

ODBC driver

To learn about the ODBC driver in Fernhill SCADA.

SQL Test Tool

To learn about the SQL Test Tool.

Glossary

For the meaning of terms used in Fernhill SCADA.

Fernhill SCADA Version 3.42. Copyright © 2012-2019 Fernhill Software Ltd: All rights reserved.