Descobrindo o Offset (fuso horário) configurado no PC.
Descrição: Como descobrir qual o Offset configurado no PC para que seja possível calcular o horário em relação ao UTC/GMT? Solução: Através do VBScript, é possivel retornar o valor do…
KB-24422: Changing a table name at run time.
Question: How can I change a Historic’s recording table name at run time? Solution: To do so, you must disable the Historic, change its TableName property to the desired new…
KB-30040: Setting a Label vertically.
Question: How can I set a Label object to be displayed vertically? Solution: You cannot set a Label to be displayed vertically; however, you can use a Text object (which…
KB-18166: Changing color in a figure according to a double point’s value.
Question: In my application, there are two PLC tags indicating the status of a circuit breaker (double point). How can I set them so a figure shows a certain color…
KB-14984: Text sliding on screen.
Question: How can I make a text slide on screen? Solution: To do so, you must first create a RampUp demo tag on Viewer. Then, on screen, add a display…
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-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…