Sql Text Transmission (Communication Action) - Mitsubishi Electric GOT 1000 Series Manual

5.1.6

SQL text transmission (Communication action)

The SQL text transmission function allows automatic creation of SQL texts, enabling communications with the database.
The following three types of commands can be selected for the SQL text.
• Select/MultiSelect
• Update
• Insert
For the SQL text transmission setting, refer to the following:
6.8.1 Setting items in Communication action
(1) Select/MultiSelect
Select/MultiSelect is used to write a database value to a tag component value area or to store it in the temporary
variable area by sending a SQL text to the database.
When a value is stored in the temporary variable area, it can be used as a variable for other actions.
(2) Update and Insert
Update and Insert are used to add a tag component value or a temporary variable to an SQL text and write the
value to the database.
Select/MultiSelect
Tag Component
Temporary variable
Update
Tag Component
Temporary variable
Constant
Insert
Tag Component
Temporary variable
Constant
Database server computer
Select...
Data
Update...
Data
Database
Insert...
Data
5.1 DB Interface Function
1
2
3
4
5
6
7
8
5 - 9