KB-34941: Executing an external program when the domain starts.
Question: How can I execute an application when the domain starts, even if there is no open E3Viewer? Solution: To do so, just place the following script at an Internal…
Author: Renan De Rossi
KB-33811: Searching the last value recorded on a table, via scripts.
Question: How can I have a script search for the last value that was recorded on a table? Solution: To do so, you must set up an SQL query that…
KB-31585: Toggling a tag's value via libraries.
Question: How can I toggle a tag’s value with a button via libraries? Solution: At the XControl’s (XC) button, write the following script: ‘If tag’s value is 1 if XC.Fonte.Tag.Value…
KB-27396: Deleting a specific batch.
Question: Can only a specific batch be deleted in Elipse SCADA? Solution: Yes, it can. To do so, you must pass all batches to temporary .DAT and .HDR files, leaving…
KB-37178: Driver for sending e-mails.
Question: What driver should I use to send e-mails via the supervisory? Solution: To do so, you must use Elipse SendMail driver.
Using RMChart in E3.
INTRODUCTION The RMChart ActiveX can be used in E3 for graphic visualization of data. In addition, this is the ideal tool for presenting statistical information, since they are loaded into…
KB-31227: Retrieving the number of records returned by a query.
Question: How can retrieve the number of records that have been returned by a query? Solution: To do so, you must use the RecordSet‘s RecordCount property. The example below shows…
KB-31207: Commands to insert, edit, and delete records in a database.
Question: How can I insert, edit and delete records of a database via E3? Solution: Via E3Studio, access the Query’s properties and then, on SQL tab, enable SQL’s edition option,…
KB-38309: Adicionando colunas ao objeto ListBox.
Descrição: É possível adicionar colunas ao objeto ListBox? Solução: Sim, é possível. Por exemplo: Screen.Item(“ListBox1”).ColumnCount = 3 Screen.Item(“ListBox1”).Clear() Screen.Item(“ListBox1”).AddItem “Row 1, Col 1” Screen.Item(“ListBox1”).List(0, 1) = “Row 1, Col 2″…
KB-38309: Adding columns to a ListBox.
Question: Can I add columns to a ListBox? Solution: Yes, you can. For example: Screen.Item(“ListBox1”).ColumnCount = 3Screen.Item(“ListBox1”).Clear()Screen.Item(“ListBox1”).AddItem “Row 1, Col 1″Screen.Item(“ListBox1”).List(0, 1) = “Row 1, Col 2” Screen.Item(“ListBox1”).List(0, 2) =…