Structured Query Language (SQL): Introduction.
This is the introduction to a series that will discuss SQL, the widely known language used for relational databases. The Structured Query Language (SQL), a very popular one for interacting…
Category: Elipse E3
Structure Query Language (SQL): Chapter 1 – Manipulating information in the DB.
Basically, information can be manipulated in the Database in three different ways: DML – Data Manipulation Language Statements: INSERT, UPDATE, DELETE, SELECT DDL – Data Definition Language Statements: CREATE, ALTER,…
Structure Query Language (SQL): Chapter 3 – Data Discard and DB Limits.
There is an important tool in Elipse E3 to help monitor a database, called data discard (available when setting up Historics, Storages, and Alarm Tables). This option enables data discard…
KB-63141: Demo application – KeyPad for Login.
Question: How can I show a virtual KeyPad when opening the Login dialog? Solution: To do so, use the following script: Sub CommandButton1_Click() Set KeyPad = Application.GetKeyPad() KeyPad.Show() …
KB-29153: Rotating Gallery images in E3Studio.
Question: How can I rotate a figure from E3Studio‘s Gallery? Solution: In E3Studio, follow these procedures: Add the desired figure to a screen. Right-click it and select the Convert to…
Disabling the Historic’s Quality column.
Question: How can I remove the Quality column from a Historic? Solution: To remove the Quality column from a Historic, you must use the Link Historic to an existing Table…
Checking the space being used by an SQL database.
Question: How can I check the size of an SQL database? Solution: To do so, you must run a Stored Procedure, available in the database. To run it in E3,…
KB-31594: Processing data from a Query.
Question: On a network containing a machine dedicated specifically to the Data Server and others to E3, where is the data from a Query inside the Viewer processed: in the…
KB-30114: Data format error in a Query.
Question: Why is the data format being regarded as month/day instead of day/month in a Query’s filter by date when the day is a number lower than 13? Solution: This…
KB-31412: Converting the Query’s E3TimeStamp into UTC/GMT time zone.
Question: How can I convert a date returned in the Query (E3TimeStamp) into UTC/GMT time zone? Solution: To do so, you can use SQL’s DATEADD function. Example: SELECT DATEADD(minute, ,…