KB-29734: SQL Query returning a single value.
Question: In an application, an SQL Query returns three values to a certain field. How can I set this Query up to return only one of them? Solution: To do…
Author: Elipse Software
KB-28443: Firing an alarm according to the values of multiple tags.
Question: How can I fire an alarm when the values of a Digital Tag and an Analog Tag are, respectively, one (01) and fifteen (15)? Solution: To do so,…
KB-30058: Setting up an E3Chart’s Y axis to display time and X axis to display values.
Question: How can I set up an E3Chart‘s vertical axis (Y) to display time and its horizontal axis (X) to display values? Solution: To do so, follow these procedures: Acess…
KB-28109: Copying a screen from one project to another.
Question: How can I copy a screen from one project to another when both belong to the same domain? Solution: To do so, go to E3Studio, select Explorer mode, choose…
KB-29259: Hardkey license.
Question: Will a hardkey from version 2.0 be detected by E3 version 3.1? Solution: No. In this case, the software won’t detect the hardkey and will be executed in Demo…
KB-26934: Linking a Historic to pre-existing table.
Question: Is it possible to link a Historic to a pre-existing table in the Database? Solution: Yes, it is possible. After setting the Historic object’s Database, just access the Link…
KB-27704: Requesting all users to log in.
Question: How can I create a screen that request all users to log in? Solution: To do so, execute the Application’s Login() function at the screen’s OnShow() event. If the…
KB-31234: Pointing to the local computer in the Database.
Question: How can I point to the local computer in the Database? Solution: To do so, go to Server field in the Database’s proprerties, erase the computer’s name and then…
KB-29436: Boolean values in E3.
Question: For Boolean values, is the number 2 considered True? Solution: Yes, any value different from 0 is considered True for Booleans.
KB-27170: Using Historic’s Average function.
Question: How can I use the historic’s Average() function? Solution: This function returns the average value of a set of data in the historic. The complete command is: Average (src,…