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
- 97
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
(b) When [Update] is selected for [Action type]
[Update] substitutes a substitute value (tag component value/variable) for a field
value of the record whose conditions are met.
Set conditions of the record to be updated in [Select/Update/Delete conditions].
(6) Select/Update/Delete conditions in this section
1) Field name (Up to 32 characters)
Set a field name for the field value to be updated.
For characters that can be used for field names, refer to the following:
Appendix 2.4 Characters available for field names, table names, stored
procedure names,etc.
For browsing the field names in the database, refer to the following:
(8) Browse field name in this section
2) Tag
Select a tag, constant, or variable which is substituted.
Note that tags with [Array setting] are not selectable.
3) Component
Select or directly enter a component/constant value/valuable that is to be
substituted.
Figure 7.72 Setting example of [Update]
Figure 7.73 Operation example of [Update]
Process1.Work_No Process1.Completed
Constant: Server time
Process1.Rejected
Work_No
Completed
Date
Rejected
536
32
2005.07.01 15:12:00
536
32
Database: DB1, Table name: CompletionReport
Tag component
Matched
Updated
Updated
Updated
496
496
2005.07.01 15:12:00
:
:
:
:
