248
13 DATABASE FUNCTION
13.3 CPU Module Database Access (from External Device) Function
Application example
This section describes the examples of database operations of the CPU module from applications in the personal computer
using the CPU module database access function. (Names of windows and menus may differ depending on the version of the
OS and application.)
The following table lists the applications whose connection to the database has been checked.
Creating a table by using an application
The following provides an example to create a recipe table in a database of the CPU module by using Microsoft Access.
Item
Description
Application
Reference
Table creation
Create a table in a database of the CPU module from the
personal computer.
Microsoft Access
Page 248 Creating a table by
using an application
Record operation
Edit a database of the CPU module from the personal
computer.
Microsoft Access
Page 251 Record operation
from an application
Record search
Search a database of the CPU module from the personal
computer.
Excel
Page 253 Record search
from an application
Database operation with the
user-created application
Create a database access application using the ODBC
classes of Microsoft .NET Framework.
User-created application
Page 255 User-created
application
Application
Version
Microsoft Access
Microsoft Office 2010, 2013, 2016
Excel
User-created application
Application created by using Microsoft .NET Framework 4.5
Ethernet
Содержание MELSEC iQ-R-R00CPU
Страница 2: ......
Страница 151: ...9 MONITOR FUNCTION 9 1 Real Time Monitor Function 149 9 MEMO ...
Страница 323: ...18 SEQUENCE SCAN SYNCHRONIZATION SAMPLING FUNCTION 321 18 MEMO ...
Страница 330: ...328 20 ROUTING SETTING 20 3 Precautions MEMO ...
Страница 423: ...26 BASIC CONCEPT 26 8 State Transition of the Redundant System 421 26 MEMO ...
Страница 524: ...522 30 MAINTENANCE AND INSPECTION FOR A REDUNDANT SYSTEM 30 1 Module Replacement in the Redundant System MEMO ...
Страница 1009: ...APPX Appendix 14 List of Available SQL Commands for CPU Module Database Access Function 1007 A MEMO ...
Страница 1014: ...1012 APPX Appendix 15 Added and Enhanced Functions MEMO ...
Страница 1027: ......