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…
Author: Renan De Rossi
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) =…
KB-37530: Opening E3 Studio with a connected runtime hardkey.
Question: Can I open the E3Studio on a server being executed with a runtime hardkey? Solution: If the hardkey has no E3Studio license, you won’t be able to open it,…