Question: Can I set a Select() and an Update() in the same SQL clause, similarly to the example below? Update EQUIPMENT Set EQUIPMENT.EQUIPMENT=’‘, EQUIPMENT.DISABLED=, EQUIPMENT.CLASS_EQUIP=CLAS_EQUIP.INDEX, EQUIPMENT.SECTOR=SECTORS.INDEXWhere EQUIPMENT.INDEX= and CLAS_EQUIP.CLASS_EQUIP=’‘ and…
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 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: 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 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: 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 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: 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,…
Question: Are Elipse E3 and Elipse SCADA compatible with Windows 64 bits? Solution: Yes, both systems have been compatible with 64-bit processors and operating systems since their following versions:…
Question: In the application, I have the following folder structure for alarms: alarms\general\se01\switch01 \switch02 \… \switch20 How can I set up the return all alarms from all switches of a…
