Mitsubishi Electric MELSEC iQ-R-R00CPU - Page 257

13 DATABASE FUNCTION
13.3 CPU Module Database Access (from External Device) Function
255
13
User-created application
The following describes a sample program for accessing the database of the CPU module with the SQL command using the
ODBC class of Microsoft .NET Framework.
■Overview of the sample program
This sample program performs the condition search in the database of the CPU module using the value of the Judge field as
its key, and displays the acquired search result in a list and graph (scatter plot).
(1)Specify the database source name to be connected.
(2)Specify the Judge field value to be searched.
(3)Click the [Search] button to search the record with the same value as the one specified by "JudgeValue" in the database specified by "DataSource".
(4)The acquired record is displayed in the list.
(5)The X value and Y value of the acquired record are displayed in a graph (scatter plot).
Ethernet
(4)
(2)
(1)
(3) (5)