Mitsubishi Electric MELSEC iQ-R Series, Programming Manual

Page: 966 / 2110

964
7 APPLICATION INSTRUCTIONS
7.21 Database Access Instructions
■
Update condition
The following figure shows the setting format of (s5). When the data type is WORD, set as many field names, condition
numbers, logical operator setting value, and determination values as there are update conditions. The data size of the
determination value follows the size of the data type of each field. (
 Page 956 DBINSERT(P))
Operand: (s5)
Device Item Description Setting range Set by
+0 Data size of the first
condition Set the data size of the first update condition. 1 to 125 User
+1 Data size of the second
condition Set the data size of the second update condition.
• 0: No condition
• Other than 0: Data size
0 to 125 User
+2 to +  Update condition Set the update conditions. The last address in (s5) varies depending on the data type
of the determination value.
■ Field name (1)
Specify the field name with a Unicode character string in 32 characters (fixed).
For the name less than 32 characters, the character string should be right-justified
and filled with 0000H to become a 32-character string.
■ Condition number (2)
Set the number indicating an update condition.
• 1: = (Equal to the determination value)
• 2: != (Other than the determination value)
• 3: < (Smaller than the determination value)
• 4: > (Greater than the determination value)
• 5: =< (Equal to or less than the determination value)
• 6: >= (Equal to or greater than the determination value)
• 7: is NULL (NULL (no value is set))
• 8: is not NULL (Not NULL (a value is set))
■ Logical operator setting value (3)
Set the operator with an adjacent condition.
• 0: No operator
• 1: AND
• 2: OR
When one update condition is specified, set the logical operator setting value of the
first update condition to 0. In this case, the second update condition is ignored if
specified.
Be sure to set the logical operator setting value of the second update condition to 0.
■ Determination value (4)
Set the value used to determine the update condition.
Also when the condition number is 7 or 8, prepare a determination value area for the
data size.

User
∙∙∙
∙∙∙
(s5)+34
(s5)+35
(s5)+2
(s5)+33
(s5)+36
(s5)+
(1)
(2)
(3)
(4)
∙∙∙ b15 b0
∙∙∙
(s5)+2
(s5)
(s5)+1
(s5)+35
(s5)+34
(s5)+33
∙∙∙
(s5)+68
(s5)+36
(s5)+70
(s5)+69
(s5)+71
(s5)+37
A data size of the 1st update condition
A data size of the 2nd update condition
Set a condition number.
Set a logical operator for an adjacent condition.
The value is fixed to 0.
Set a condition number.
A condition for
the 1st field
Determination value
Logical operator setting value
Determination value
Condition number
Logical operator setting value
Condition number
Field name
Field name
A condition for
the 2nd field