Filter
Top Products
7
MES INTERFACE FUNCTION CONFIGURATION TOOL
7.11 Job Setting - Actions
7.11.1 Setting items in Communication action
7
- 91
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
*1 When using the operation field, the insertion function (INSERT) and update function (UPDATE)
cannot be executed for the operation field (for Microsoft
®
Access
®
2010, and Microsoft
®
Access
®
2013).
*2 Not available for [Select/Update/Delete conditions].
*3 When using "Select" and "MultiSelect" for a field whose data type is single type or double type,
perform the following. (for Microsoft
®
Access
®
2007, Microsoft
®
Access
®
2010, and Microsoft
®
Access
®
2013)
• Select "Microsoft Access Driver (*.mdb)" in the ODBC setting for the database used.
Section 8.2 (3) For Microsoft
®
Access
®
• When the database source file used is "*.accdb", change it to "*.mdb".
*4 Memo-type fields in Rich Text Format cannot be used (for Microsoft
®
Access
®
2007, Microsoft
®
Access
®
2010, and Microsoft
®
Access
®
2013).
*5 Values are assigned with precision of six decimal digits.
(4) Display format of tag component/constant/variable for generated SQL text/
execution procedure
The components/constant values of the action being edited or the tag components/
constants/variables set to the condition value in "update/insert/delete" are displayed in
"Generated SQL text" and "Execution procedure" with the following format.
The Tag component, Module time, Data String, and Variable are generated at job
execution, therefore, they are different from the actual SQL text and stored procedure
call information.
Table 7.71 Display format of the tag component/constant value
Item Display format
Tag component
Displayed enclosed
with '( )'.
'(Device tag name, component name)'
Numerical value
Access
®
Only the setting
content is displayed.
Number
Other than the above
Displayed enclosed
with single quotes (').
'Number'
String 'String'
Date
Server time
Oracle
®
8i
Displayed as shown
on the right.
sysdate
Access
®
NOW()
Other than the above CURRENT_TIMESTAMP
Module time
Oracle
®
Displayed as shown
on the right.
TO_DATE('(Date[YYYYMMDDhhmmss])',
'YYYYMMDDHH24MISS')
Other than the above '(Date[YYYY-MM-DD hh:mm:ss])'
Date String
Displayed as '(Date [
])'.
'(Date[String])'
Variable
Displayed enclosed
with '( )'.
'(Variable name)'
Table name
Only the setting
content is displayed.
Table name
Field name Field name
Stored procedure name Stored procedure name