Update Command

Update Command

In this field, the user will configure an  update query to update the desired columns from one or more tables.

This field will accept "UPDATE SET" statements and also Stored Procedures.

Example:

Database Configuration:

.      Table name: Test

.     Columns: ID, Name, InitialDate, Status

Query Configuration:

.     UPDATE Test SET Name = 'John' => Updates the value of the column name to John

The variables on the UPDATE are:

.     $$tb: is the Table of the DataBase

.     $$val: is the Value field of the DataBase

.     $$valval: is the Value of the configured tag

.     $$qual: is the Quality field of the DataBase

.     $$valqual: is the Quality of the configured tag

.     $$ts: is the TimeStamp field of the DataBase

.     $$valts: is the TimeStamp of the configured tag

.     $$key: is the Key field of the DataBase

.     $$valkey: is the Key of the configured tag