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-13317: Changing the picture on a button at runtime.
Question: At runtime, how can I change the picture loaded in a button’s Picture property? Solution: To do so, use LoadPicture method. Example: Screen.Item(“CommandButton3”).Picture = LoadPicture (“D:\TEMPPuc1.bmp”)
KB-26430: Creating multiple objects on a screen.
Question: What is the best way to create 500 different Displays on screen? Can I do this automatically, or only manually? Solution: To do so, there are two possibilities: At…
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-29076: Sequence of Events (SOE).
Question: How can I perform a Sequence of Events (SOE) in E3? Solution: This can be done in two ways: via alarms settings, or via I/O Driver’s OnTagRead event. How…
KB-24714: Number of fields in a Historic.
Question: What is the maximum amount of fields a Historic can have in an E3 application? Solution: It will depend on your database. SQL Server accepts up to 1024 columns…
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-27977: Deleting the records stored in a database.
Question: How can I delete all the records from a database via E3? Solution: To do so, you have to create a Query and, in it, set up the SQL…
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…