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…
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…
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,…
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…
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…
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…
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…
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…
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…
Question: For Boolean values, is the number 2 considered True? Solution: Yes, any value different from 0 is considered True for Booleans.
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,…