Filter
Top Products
7
- 94
7.11 Job Setting - Actions
7.11.2 Setting items in Communication action (Select/Update/Insert/MultiSelect/Delete)
7
MES INTERFACE FUNCTION CONFIGURATION TOOL
(1) Action type
Select an action type.
*1 Cannot be selected when the database is Wonderware
®
Historian.
(2) Database
Select a database to be accessed.
(3) Table name (Up to 32 characters)
Set a table name of the database to be accessed.
For characters that can be used for table names, refer to the following:
Appendix 2.4 Characters available for field names, table names, stored
procedure names,etc.
For browsing the table names in the database, refer to the following:
(4) Browse table name in this section
Table 7.73 Selection items for [Action type]
Item Description
Select
*1
Substitutes a field value of the record, whose conditions are met, for
a substitute value (tag component value/variable).
Update
*1
Substitutes a substitute value (tag component value/variable) for a
field value of the record whose conditions are met.
Insert
Generates a new value, and inserts an insert value (tag component
value/constant value/variable) into a field of the generated record.
MultiSelect
*1
Substitutes field values of the records, whose conditions are met, for
substitute values (tag component values).
Delete
*1
Deletes a specific record by specifying a database and a table.