FAQ


FAQAbout Products

- FAQ > Controllers > Programmable Controllers MELSEC > MELSEC iQ-R Series > How to use the database function of the MELSEC iQ-R series
FAQ
How to use the database function of the MELSEC iQ-R series
How can I use the database function of the MELSEC iQ-R series?
- Category :
Answer
The database function manages tabular data including product information and production information as a database
in a programmable controller.

<How to create a database>
(1) Create a Unicode text file in which the configurations of the database and its tables have been defined.
(2) Write the created Unicode text file into an SD memory card.
(3) Specify the Unicode text file and execute the "DBIMPORT(P)" instruction.
A database folder is created in the folder where the Unicode text file has been stored and the database is constructed.
[Example: Format example of the Unicode text file]

<How to use the database>
(1) Execute the DBOPEN(P) instruction to connect to the database that you want to work on.
(2) Operate the database (addition/update/search/deletion of data).
(3) Execute the DBCLOSE(P) instruction to disconnect the connection to the database.

For details on the database function and access instructions, refer to the following manual.
- MELSEC iQ-R CPU Module User's Manual (Application)
2. FUNCTIONS 13. DATABASE FUNCTION
in a programmable controller.

<How to create a database>
(1) Create a Unicode text file in which the configurations of the database and its tables have been defined.
(2) Write the created Unicode text file into an SD memory card.
(3) Specify the Unicode text file and execute the "DBIMPORT(P)" instruction.
A database folder is created in the folder where the Unicode text file has been stored and the database is constructed.
[Example: Format example of the Unicode text file]

<How to use the database>
(1) Execute the DBOPEN(P) instruction to connect to the database that you want to work on.
(2) Operate the database (addition/update/search/deletion of data).
(3) Execute the DBCLOSE(P) instruction to disconnect the connection to the database.

For details on the database function and access instructions, refer to the following manual.
- MELSEC iQ-R CPU Module User's Manual (Application)
2. FUNCTIONS 13. DATABASE FUNCTION
- Product Name
- MELSEC iQ-R Series
- Series
- MELSEC iQ-R Series
May I have your opinion?
Related FAQ
- Database function of the MELSEC iQ-R series
- IP filter function of MELSEC iQ-R series CPU modules
- Built-in Ethernet function setting window of MELSEC iQ-R series CPU modules
- How to prevent unauthorized access to MELSEC iQ-R series CPU modules via a network
- Combination of the MELSEC iQ-R series inter-module synchronization function and another network synchronous communication function