Sum total filtered by date with OVER(Transact-sql) clause.
This article shows how to retrieve the sum total of an estimated time period by using OVER clause alongside WHERE clause in Elipse E3. According to Microsoft’s documentation, the OVER…
Category: DataBases
KB-108744: Returning Elipse E3’s active alarms via database.
Question: How can I return the active alarms in Elipse E3 via database records? Solution: In order to return the active alarms in Elipse E3 (acknowledged or not), you must…
KB-106987: Subtracting record values in a table Field.
Question: There is a table field that receives the tag whose value is the total sum of a certain variable in the system; however, I need to subtract these record…
Returning a value not recorded in the Database.
This article illustrates how to return a value that has not been recorded in the Elipse E3 Database yet. Many times, you will need to check if a certain value…
Tutorial for Microsoft SQL Server Express 2017 installation and configuration.
This article shows you how to install and configure SQL Server Express 2017, free version of Microsoft Database, and SQL Server Management Studio (SSMS), and how to use them as…
KB-97376: Error when executing Stored Procedure in Oracle DB.
Question: How can I work around a syntax error in a stored procedure in an Oracle database? I developed a stored procedure in an Oracle 11g databse which returns an…
Communication between Elipse E3 and Amazon Relational Database Service (Amazon RDS).
The Amazon Relational Database Service (Amazon RDS) is a web service that enables the configuration, operation, and scalability of a relational database in the cloud. This service provides users with…
Demo application: Reading data from an SQL database via VBScript driver.
This article uses a demo application to illustrate how to read data from an SQL database via VBScript driver, by Elipse Software. Introduction Sometimes, you will need your Elipse application…
KB-102503: Replacing Elipse E3 queries with Stored Procedures in the database.
Question: I have a low performing application due to the many queries being executed cyclically in Elipse E3. In this case, can I replace these queries with Stored Procedures? Will…
Migrating Access databases to SQL Server 2017.
This article will show you how to migrate an Access database to SQL Server 2017. To do so, just follow the instructions below: First, copy the Access database. Soon after,…