NOTE: Advanced mode is required to reverse the order on the SQL Table. By default the SQL Query Result Viewer will visualize data in ascending order. To change it to descending order will require enabling Advanced Mode under [Data/History] > [SQL Query] > double click on an SQL Query instance > Enable [Advanced Mode]. Once…
There is a touchscreen calibration procedure that you should run when connecting a new touchscreen to the cMT-FHDX. Log on to the cMT-FHDX from your web browser by entering
the IP address of the cMT in the URL field. This will open the WebView window.
Read More Can a cMT SQL Advanced Query command call a SQL Stored Procedure?
As of EBPro v6.05.02, the SQL query command limit will allow up to 2000 characters.
Read More How many characters are allowed in an Advanced SQL Query command?
There are no macro instructions that allow a macro to directly interface with table data in a SQL database. The data would need to be copied from the database into local HMI memory before it can be accessed by the macro, which is tedious if large amounts of data need to be manipulated. It is…
Read More Interfacing with an SQL database table: the SQL Advanced Query Object vs. Macro
Yes, create a SQL Query command and insert the SQL syntax. If the SQL syntax is executable in the database management tool (ex. Microsoft SQL Management Studio) then it will work in EBPro. The cMT is just a SQL client that relays the syntax to the database server
Read More Can I use a cMT to call a stored procedure in an SQL database?
MySQL is the world’s most popular open source database. With its proven performance, reliability, and ease-of-use, MySQL has become the leading database choice for web-based applications. Additionally, it is an extremely popular choice as embedded database, distributed by thousands of software vendor- and OEMs.
MySQL is a powerful tool that can be used with select HMIs to help collect and display data for easier monitoring and analytics. MySQL is a relational database management system that uses SQL, or Structured Query Language, as the query language to access data in the database. By connecting a Maple Systems HMI to a…
Microsoft® SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications-which may run either on the same computer or on another computer across a network (including the Internet).
Both MySQL and MS SQL Server are widely used Relational Database Management System (RDBMS). MySQL is an open source, whereas SQL Server is a Microsoft® product. Microsoft® allows enterprises to choose from several editions of SQL Server according to their needs and budget. Both MySQL and SQL Server support multiple programming languages. Both RDBMS support…
Read More What is the difference between MySQL and Microsoft® SQL?
Microsoft® SQL Server can be used with our High Performance series to help collect and display data for easier monitoring and analytics. The High Performance series also support a built-in database query viewer which enables production machines to retrieve data from your central SQL database. By connecting a High Performance HMI product to an SQL…
Read More What Maple Systems products support Microsoft® SQL?
Yes. MySQL and Microsoft® SQL Server are well supported database options that can be used with our Advanced and High Performance HMIs to help collect and display data for easier monitoring and analytics. They also support a built-in database query viewer which enables production machines to retrieve data from your central SQL database. By connecting…
Read More Can Maple Systems support SQL Database Integration?
Please note that steps to connect to a SQL database depend on the configuration and location of the SQL database. For example, a SQL database may reside on the physical Industrial PC, in a virtual machine, or on a remote SQL Server on or off your network. TROUBLESHOOTING STEP:1. Verify that SQL Server port is…