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”)
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…
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…
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…
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…
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…
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…
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…
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”,…
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…