Mitsubishi Electric SW1DNC-MESIF-E - Page 246

7 - 88
7.11 Job Setting - Actions
7.11.1 Setting items in Communication action
7
MES INTERFACE FUNCTION CONFIGURATION TOOL
(2) About constants
Constants can be used as component values for each action or as condition
values of [Select/Update/Delete conditions].
The following table lists constant types and the data types of assignable fields.
If the type of a constant does not match the data type of its substitution target
field, an error occurs, resulting in cancellation of job execution.
Table 7.69 Constant types and the data types of assignable fields
Constant
type
Values that can be entered in [Component]
Data type of assignable field
Oracle
®
SQL Server
®
MSDE 2000
Access
®*1
Wonderware
®
Historian
[Number]
Up to 16 characters
• Signed decimal notation
(Example: -521.98)
• Signed exponential notation
(Example: -5.2198E03)
NUMBER
bit
*2
int
*2
smallint
*2
tinyint
*2
float
real
Yes/No type
Byte type
Integer type
Long Integer type
Single type
*3
Double type
*3
AutoNumber type
Currency type
Discrete Tag
Analog
Tag(Integer)
Analog
Tag(Real)
[String]
Up to 32 characters
For characters that can be used for character
strings, refer to the following:
Appendix 2.3 Characters available for
character string constants, etc.
CHAR
VARCHAR
char
varchar
text
*4
Text (Sh ort Text)
type
*5
Memo (Long Text)
type
*5
String Tag
[Date]
*6
• When using the date and time of the
database server: [Server time]
*7
• When using the date and time of the MES
interface module: [Module time]
DATE
datetime
smalldatetime
Date/Time type
-
*8
[Date
String]
Up to 32 characters
For characters that can be used for character
strings, refer to the following:
Appendix 2.3 Characters available for
character string constants, etc.
Specify the date and time of the MES
interface module in the following format.
Year (4 digits): YYYY
Year (2 digits): YY
Month (2 digits): MM
Day (2 digits): DD
Hour (2 digits): hh
Minute (2 digits): mm
Second (2 digits): ss
Example:"YYYY-MM-DD hh:mm:ss"
"2005-07-01 15:12:00"
CHAR
VARCHAR
char
varchar
text
*4
Text (S hor t Text)
type
*5
Memo (Long Text)
type
*5
String Tag