Mitsubishi Electric MELSEC iQ-R Series Programming Manual page 973

The following figure shows the setting format of (s4). (In the case of data type WORD)
Set as many field names, condition numbers, logical operator setting values, 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))
b15 ∙∙∙
(s4)
(s4)+1
(s4)+2
(s4)+3
Field name
(s4)+4 to
(s4)+35
(s4)+36
Condition number
Logical operator setting value
(s4)+37
Determination value
(s4)+38
Field name
(s4)+39 to
(s4)+70
(s4)+71
Condition number
(s4)+72
Logical operator setting value
(s4)+73 Determination value
■Search result
Operand: (d1)
Device Item
+0 Number of outputs
+1 to + Output value
The following figure shows the setting format of (d1). Data is output according to the data type corresponding to the field
specified by (s3).
b15 ∙∙∙
(d1)
(d1)+1
1
n
1
n
(d1)+
b0
A data size of the 1st search condition
A data size of the 2st search condition
Maximum size of the search result
Maximum number of records can be output
Set a condition number.
Set a logical operator for an adjacent condition.
Set a condition number.
The value is fixed to 0.
Description
The number of records that meet the condition set in (s4) is output.
The number of outputs should be within the maximum number of outputs set in
(s4)+3, and any record exceeding the maximum number of outputs is not output.
The value of the records that meet the condition set in (s4) is output.
Records are output right-justified in the range from (d1) to (d1)+(maximum
output size), and any record that does not fit in the range is not output.
b0
Set the number of output records, 'm'.
An output value of the 1st field
An output value of the 'n'th field
An output value of the 1st field
An output value of the 'n'th field
A condition for the
1st field
A condition for the
2nd field
Setting
range
0 to 64
Depends
on the data
type
Data for one Data for 'm'
record records
7 APPLICATION INSTRUCTIONS
7.21 Database Access Instructions
7
Set by Data
type
System WORD
System
971