KB-14396: Disabling the space bar.
Question: How can I disable Click() event via space bar in certain buttons of the application? (That is, I want to keep E3 from interpreting the space bar being pressed…
KB-31698: Número de clientes SQL necessários em uma aplicação E3.
Descrição: Quantas cópias de produto para clientes SQL são necessárias em uma aplicação com dois E3Servers (funcionando como Hot-Standby) e cinco Viewers? Solução: Toda a comunicação do E3 com o…
KB-13330: Setting a Historic to only record data per event.
Question: How can I set a historic to record data in the database only when there is an event, and not automatically/by scan? Solution: To do so, go to Historic…
KB-20214: SQL function to calculate maximum, minimum, and average values.
Question: How can I set an SQL query (Access database) to retrieve the tag’s maximum, minimum, and average values? Solution: To do so, you must use MAX, MIN, and AVG…
KB-29522: Opening a screen from a frame on another frame.
Question: On a frame, how can I open a screen on another frame? Solution: To do so, you can use a script with methods GetFrame() and OpenScreen(). Example: Application.GetFrame(“”).OpenScreen “NameOfTheFrame”,…
KB-28190: Filter in SQL Query using time value.
Question: How can I query a certain period (initial and final date), while also adding filter it by hour within this period? (For example: the query must return data only…
KB-27418: Storing historic alarms in E3Alarm.
Question: Can E3Alarm store the acknowledged alarms that have already returned to the normal status? That is, is it possible not to remove them from the list, so that they…
KB-28636: Setting up alarm’s Message column’s width and name.
Question: How can I set up the alarm’s Message column’s width and name?Solution: Via E3Studio, go to E3Alarm’s properties window, and on Columns tab select the name of the column…
KB-13180: SQL query returning values every 10 minutes.
Question: How can I have an SQL query return values every ten minutes, even when the Historic keeps recording these values every second? Example: 4h 30min – tag1 = 1…
KB-29341: Using tag’s timestamp for viewing and recording alarms.
Question: How can I use the timestamp of a tag read via DNP driver for viewing and recording alarms? Solution: To do so, use InTime timestamp, which can be selected…