TechTip: SQL Query With Weintek cMT Series HMI

In addition to being able to syncronise datalogs and alarm/event logs to a MySQL or MS SQL database, you can now read, update, delete and append databases using the SQL query object. Steps1. Create your database on your MySQL or MS SQL database server. I have called mine “database” and created a table on it called “plcdata“. idplcdata is the primary key and data is the column for the data I want to record. 2. Setup Database Server in EasyBuilder Pro project. I am running MySQL locally on my PC for testing, so IP address is set to local – Continue reading TechTip: SQL Query With Weintek cMT Series HMI