SQL Query: Accessing SQLite Database Stored in USB/SD

by weintek-forum · Published October 15, 2018 · Updated October 22, 2018

Before, HMI can only access database by connecting remotely with MySQL or Microsoft SQL database server, now by using SQL Query, accessing SQLite database stored in a USB disk or SD card is possible. This feature is supported from EasyBuilder Pro v6.01.02.

There are two intuitive ways to designate file path of database: Static or Dynamic.
When using a static directory, the user can simply enter the full pathname of the database file in the provided field.
When using a dynamic directory, an address can be designated as the data source for the file path.

Static

Dynamic
A File Browser object can be used to shorten the time it takes to enter the file path. By designating the same address for both File Browser and SQL Query, the file path can be simultaneously written to SQL Query when selecting a file in File Browser.