Mitsubishi Electric MELSEC iQ-R-R04CPU - Chapter 13 Database Function

232
13 DATABASE FUNCTION
13 DATABASE FUNCTION
This function manages the data such as product information or production information as a database in an SD memory card of
the CPU module.
Database access instruction
The database access instructions allow the databases of product information and production information to be created, input,
updated, edited, searched, transacted, and rolled back.
CPU module database access (from external device) function
The CPU module database access function enables operations such as table creation and record operation/search of the
database built in an SD memory card inserted into the CPU module.
• This function cannot be used in the R00CPU, R01CPU, and R02CPU.
RnCPU
RnENCPU
RnPSFCPU RnPSFCPU RnSFCPU RnSFCPURnPCPURnPCPU
(Standard) (Safety) (Standard) (Safety)
(Redundant) (Process)
DBSELECT
DBINSERT
1234
1235
1
2
2017/4/28 15:40:30
2017/4/28 15:41:15
81
79
99
100
58
60
80
40
1
2
100
90
60
40
Read the data of product
ID = 2.
Database (Product information table)
Database (Production information table)
Database is built in an SD memory card.
Product
information
Production
information
Write the processing data
to the production result.
Product
number
Product
ID
Result(X) Result(Y) Result(Z)Processing date
Product ID Product name Size(X) Size(Y) Size(Z)
Product name 1
Product name 2
Ethernet
Product
information
Production
information