Start main contents

  • Font Size
  • S
  • M
  • L

Questions

  • No : 22476
  • Release Date : 2018/09/03 17:28
  • Update : 2018/09/19 14:44
  • Print

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
Product Name
MELSEC iQ-R Series
Series
MELSEC iQ-R Series
Did you solve your question?

If it is not resolved please ask from here.

Contact Us

May I have your opinion?