English (United States)
Call us! 512-349-0334 or (877) INDUSOFT

InduSoft Sample Applications

Below you will find many applications created using InduSoft Web Studio or CEView. These applications were created using various versions. Feel free to download the applications and use them for ideas for your own projects and as an understanding how the features work within the InduSoft product family.

Need help getting your project communicating to your PLC, controller, or other device? Click here to see the list of Communication Example downloads.

Click on the application name or the thumbnail to download.

SQL Query Project

File Size 750.5 KB
InduSoft Web Studio Version 71.3.0 or later
Platform
Application Revision
Original Filename SQLQueryProject.zip

This project demonstrates the use of manual SQL Queries and some display methods. On the opening screen, Boolean and analog alarm data can be generated which is written into the “ProjectDB.mdb”, where it can be viewed and deleted, and on the second screen, data can be manually (ad hoc) queried from a portion of the MS Access test database “Northwind.mdb” or the “ProjectDB.mdb. The connection strings use the “Jet OLEDB 4” MS Office components driver/provider which is compatible with the Access .mdb files, and the connection string also uses the embedded function {$GetAppPath{)} to point to the databases in the project root folder. The Jet 4 driver/provider should already be on your machine if Office components have been installed. Other databases such as Access “.accdb” files using the Jet 12 driver, SQL Server Express, or MySQL can be used if the compatible driver/provider is installed on the machine and the connection strings are changed to use the new driver/provider. A blog with instructions for using application demonstrating the Jet 12 driver and .accdb files is located here: http://www.indusoft.com/blog/2013/06/18/how-to-create-an-ad-hoc-sql-query-in-indusoft-web-studio/

Download Back