Mitsubishi Electric MELSEC iQ-R Series - Page 974

972
7 APPLICATION INSTRUCTIONS
7.21 Database Access Instructions
Ex.
When retrieving "Size(z)" with ID = 0001H using the DBSELECT(P) instruction
(1) Second condition data sizeWORD type (1 word)
(2) 0 for the second condition which is not used
(3) Maximum output size  20 words
(4) Maximum number of outputs  Default (0)
(5) Field name of first search condition
(6) The condition number is "=". Set K1.
(7) No logical operator setting value is used. Set K0.
(8) Set K1 for the determination value.
(9) K60 is output in WORD type (1 word).
ID
0001H
0002H
Size(x)
80
40
·
Size(y)
100
90
Size(z)
60
40
Product
[Product information table (proInfo)]
"AAA1"
"BBB2"
Database
DBSELECT D0 D10 D100 D300D200 M0 D500
D200 0001H →(1)
D201 0000H →(2)
D202 K20 →(3)
D203
D204
K0 →(4)
(5)
D
D206 0000H
·
D235 0000H
D236 K1 →(6)
D237 K0 →(7)
D238 K20 →(8)
D10 p
I
n
o
D17 0000H
·
D42 0000H
f
r
o
D100 0001H
I
D101 S
D108 0000H
·
i
z
e
(
z
)
D132 0000H
→(9)
D300 0001H
D301 K60
The program searches and outputs the
Size(z) value of ID 0001H by using the
DBSELECT instruction.
[Program]
[Table name]
[Number of fields] [Conditions]
Set conditions to search the value of
ID 0001H.
[Field name]
[Output result]
[Searched value]
1 record