KB-49201: Using Log10 function and Case/Else commands in an SQL query.
Question: How can I have a Query’s Log10 function be executed only in rows different from 0 (zero), leaving rows equal to zero with value 0 (zero)? Solution: To apply…
Category: E3Query
Retrieving averages of time (minutes, hours, and days) from an SQL Server database.
In this article, we will show you how to retrieve the averages from the table fields in an SQL Server database of three different time units: minutes, hours, and days.…
Setting up where E3 application’s queries will be executed.
Question: Where are E3 application’s queries executed: in the Viewer or in the Server? Solution: This will depend on EnableLocalCreation property’s value. If EnableLocalCreation property is set as TRUE, the…
KB-31227: Retrieving the number of records returned by a query.
Question: How can retrieve the number of records that have been returned by a query? Solution: To do so, you must use the RecordSet‘s RecordCount property. The example below shows…
KB-31207: Commands to insert, edit, and delete records in a database.
Question: How can I insert, edit and delete records of a database via E3? Solution: Via E3Studio, access the Query’s properties and then, on SQL tab, enable SQL’s edition option,…
KB-26598: Retrieving data from two tables alternately.
Question: How can I use a Query to retrieve data from two tables alternately if they have the same columns structure? Solution: To do so, you must edit the Query’s…
KB-37200: Displaying a single register with the InTime and OutTime information in E3 Browser.
Question: How can I display the InTime and OutTime information from an alarm occurrence a single register in E3 Browser? Solution: To do so, we suggest that you use the…
KB-30218: LIKE clause not working on a Query
Question: Why is a Query’s filter using the LIKE clause not working when typing just a part of the word to be filtered? For example, when typing “tag”, only the…
KB-37302: Setting a filter by date on an E3Storage’s Query.
Question: How can I set a filter by date on an E3Storage’s Query? Solution: To do so, you must use the CompressedDataStartEndTime query and set the dates in the respective…
KB-27586: Adding values of a Query field and showing it in a Display.
Question: How can I add the values of a Query field and show the result in a Display? Solution: To do so, you must use SUM() function in the SQL…