Mitsubishi Electric MELSEC iQ-R Series - Page 973

7 APPLICATION INSTRUCTIONS
7.21 Database Access Instructions
971
7
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))
■Search result
The following figure shows the setting format of (d1). Data is output according to the data type corresponding to the field
specified by (s3).
Operand: (d1)
Device Item Description Setting
range
Set by Data
type
+0 Number of outputs 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.
0 to 64 System WORD
+1 to + Output value 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.
Depends
on the data
type
System
(s4)
(s4)+1
(s4)+2
(s4)+3
(s4)+38
(s4)+36
(s4)+37
(s4)+71
(s4)+72
(s4)+73
b15 b0
Condition number
Logical operator setting value
Determination value
Condition number
Logical operator setting value
Determination value
Field name
(s4)+4 to
(s4)+35
Field name
(s4)+39 to
(s4)+70
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
A condition for the
1st field
A condition for the
2nd field
Set a condition number.
Set a logical operator for an adjacent condition.
Set a condition number.
The value is fixed to 0.


b15 b0

(d1)
(d1)+1
(d1)+
n
1
n
1
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
Data for one
record
Data for 'm'
records