Mitsubishi Electric MELSEC iQ-R Series - Page 967

7 APPLICATION INSTRUCTIONS
7.21 Database Access Instructions
965
7
Ex.
When updating Output of a record with ID = 0002H to 35 using the DBUPDATE(P) instruction
(1) Second condition data sizeWORD type (1 word)
(2) 0 for the second condition which is not used
(3) Field name of first update condition
(4) The condition number is "=". Set K1.
(5) No logical operator setting value is used. Set K0.
(6) Set K2 for the determination value.
ID
0001H
0002H
0003H
Output
32
35
38
·
Product
[Production result table (proReport)]
"AAA1"
"BBB2"
"CCC3"
Database
DBUPDATE D0 "proReport"
D100 0001H
D100 D300D200 M0 D500
D300 0001H →(1)
→(2)
(3)
D
D304 0000H
·
D333 0000H
D334 K1 →(4)
D335 K0 →(5)
D336 K2 →(6)
D101 O
p
u
D107 0000H
·
D132 0000H
t
u
t
D200 0001H
D202 K35
I
0000H
The program updates the information of ID 0002H
by using the DBUPDATE instruction.
[Program]
Table name
[Number of fields]
[Field name]
[Conditions]
[Record size]
[Setting value]
WORD type (1 word)
K35 is set.