Filter
Top Products
7
- 90
7.11 Job Setting - Actions
7.11.1 Setting items in Communication action
7
MES INTERFACE FUNCTION CONFIGURATION TOOL
(3) About variables
Variables can be used as component values for each action or as condition values
of [Select/Update/Delete conditions].
The following table lists data types of variables and those of assignable fields.
If the type of a variable does not match the data type of its substitution target field,
an error occurs, resulting in cancellation of job execution.
Up to 64 variables can be set for one job.
(1) A variable is valid only in a single job execution and is not held.
(2) The initial variable value before substitution processing is the numerical value
of zero.
(3) If a type that cannot be converted is assigned to a tag component when a
substitution tag is the tag component, "Type conversion to tag component
error" is displayed.
Check the source type and the data type of the tag component.
Section 7.15 (5) Type mismatch
Table 7.70 Data types of variables and those of assignable fields
Data type of variable
Values (variable names) that
can be entered in [Component]
Data type of assignable field
Oracle
®
8i/9i/
10g/11g/12c
SQL Server
®
2000/2005/
2008/2012
MSDE 2000
Access
®
2000
Access
®
2003/2007/
2010/2013
*1
Wonderware
®
Historian
(Numeric type: Integer)
Bit type
Single-precision type
Double-precision type
Up to 16 characters
For characters that can be used
for variables, refer to the
following:
Appendix 2.2 Characters
that can be used for item
names, component names,
variable names, etc. in the
product
NUMBER
CHAR
VARCHAR
bit
int
smallint
tinyint
float
real
char
varchar
text
*2
Yes/No type
Byte type
Integer type
Long Integer type
Single type
*3
Double type
*3
AutoNumber type
Currency type
Text type
*2*4
Memo type
*2*4
Discrete Tag
Analog
Tag(Integer)
(Numeric type: Floating
point)
Floating-point type
*5
NUMBER
CHAR
VARCHAR
float
real
char
varchar
text
*2
Single type
*5
Double type
*5
Text type
*2*4
Memo type
*2*4
Analog
Tag(Real)
Character string
CHAR
VARCHAR
char
varchar
text
*2
Text type
*4
Memo type
*4
String Tag