The SQL Data block can read data from the iFIX process database or your relational database. After reading the data, the SQL Data block can write it to either database depending on the SQL command that executes.
|
If the SQL command is... |
The block... |
|
SELECT |
Reads values from the relational database and writes them to the process database. |
|
INSERT, UPDATE, or DELETE |
Writes process data values to the relational database |
A SELECT command with a Where clause instructs the block to read and write data to both databases. For values in the Where clause, the block reads from the process database and writes them to the relational database. However, for the values not in the Where clause, the block reads from the relational database and writes to the process database.
