Mitsubishi Electric MELSEC iQ-R Series - Page 979

7 APPLICATION INSTRUCTIONS
7.21 Database Access Instructions
977
7
■Applicable devices
■Deletion condition
*1 Set as many field names, condition numbers, logical operator setting values, and determination values as there are update conditions.
(Page 962 DBUPDATE(P))
Operand Bit Word Double word Indirect
specification
Constant Others
X, Y, M, L,
SM, F, B, SB,
FX, FY
J\ T, ST, C, D, W,
SD, SW, FD, R,
ZR, RD
U\G, J\,
U3E\(H)G
Z LT, LST,
LC
LZ K, H E $
(s1)         
(s2)   
(s3)         
(d1)         
(d2)         
Operand: (s3)
Device Item Description Setting
range
Set by Data
type
+0 Data size of the first
condition
Set the data size of the first deletion condition. 1 to 125 User WORD
+1 Data size of the
second condition
Set the data size of the second deletion condition.
• 0: No condition
• Other than 0: Data size
0 to 125 User
+2 to + Deletion condition
*1
Set the deletion conditions. Set as many deletion conditions as there are records
to be deleted.
The last address in (s3) 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 a deletion 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 deletion condition is specified, set the logical operator setting value of
the first deletion condition to 0. In this case, the second deletion 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. The data size of the
determination value follows the size of the data type of each field. (Page
956 DBINSERT(P))
Also when the condition number is 7 or 8, prepare a determination value area for
the data size.
 User

(s3)+34
(s3)+35
(s3)+2
(s3)+33
(s3)+36
(s3)+
(1)
(2)
(3)
(4)