Filter
Top Products
7
MES INTERFACE FUNCTION CONFIGURATION TOOL
7.11 Job Setting - Actions
7.11.2 Setting items in Communication action (Select/Update/Insert/MultiSelect/Delete)
7
- 103
1
OVERVIEW
2
SYSTEM
CONFIGURATION
3
SPECIFICATIONS
4
SETTINGS AND
PROCEDURE TO
OPERATION
5
INSTALLATION AND
UNINSTALLATION
6
FUNCTIONS
7
MES INTERFACE
FUNCTION
CONFIGURATION TOOL
8
DB CONNECTION
SERVICE AND
SETTING TOOL
(6) Select/Update/Delete conditions
When [Select], [Update], [MultiSelect] or [Delete] is selected for [Action type], set
conditions for the records to be selected, updated, multi-selected or deleted.
When a field value of a record matches a condition value, the record is selected,
updated or deleted.
Up to 8 rows can be set for one communication action in [Select/Update/Delete
conditions].
(1) Exception processing is executed when:
• Records to be selected/updated/multi-selected/deleted do not exist.
(9) (a) Exception processing: No applicable record in this section
• Multiple records exist for select/update/delete.
(9) (b) Exception processing: Multiple applicable records in this
section
• The number of records to be multi-selected is greater than the number of
arrays set in [Array setting] of the tag.
(9) (c) Exception processing: Applicable records overflow in this
section
(2) Be careful not to create significant number of selected/updated records due to
the select/update/delete conditions.
Failure to do so may affect performances of the data base or the system.
(3) When [Update] or [Delete] is selected for [Action type] and multiple records
are found to be updated or deleted, all of them will be updated or deleted.
If the [Select/Update/Delete conditions] area is blank, all records of the
specified table will be selected, updated, or deleted.
Figure 7.81 [Select/Update/Delete conditions]