Mitsubishi Electric MELSEC iQ-R Series Programming Manual page 979

■Applicable devices
Operand Bit
X, Y, M, L, J\
SM, F, B, SB,
FX, FY
(s1)  
 
(s2)
(s3)  
 
(d1)
(d2)  
■Deletion condition
Operand: (s3)
Device Item
+0 Data size of the first
condition
+1 Data size of the
second condition
*1
+2 to + 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))
Word
T, ST, C, D, W, U\G, J\,
SD, SW, FD, R, U3E\(H)G
ZR, RD
 
 
 
 
 
Description
Set the data size of the first deletion condition.
Set the data size of the second deletion condition.
• 0: No condition
• Other than 0: Data size
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.
(s3)+2
(1)
(s3)+33
(s3)+34
(2)
(s3)+35
(3)
(s3)+36
(4)
(s3)+
■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.
Double word Indirect
specification
Z LT, LST, LZ
LC
   
   
   
   
   
Setting
range
1 to 125
0 to 125

7 APPLICATION INSTRUCTIONS
7.21 Database Access Instructions
Constant Others
K, H E $
   
   
   
   
   
Set by Data
type
User WORD
User
User
7
977