KB-31795: Recording values in an Access database’s table.
Question: How can I record tag values in an Access database’s table? Solution: To do so, you must first create an Access database with a table. Then, create an ODBC…
Author: Elipse Software
Searching for dates with SQLQuery function.
Question: How can I search for dates with SQLQuery function? Solution: To do so, the comparison value of Date/Time field must be between “#” signs, as seen below: SQLQuery(“DateTime =…
KB-34756: Inserting records in the middle of the historic.
Question: Can I insert a record in the middle of a historic? Solution: Yes. To do so, create a temporary historic, and then create a script that executes the following…
KB-31722: Remote application issues in Windows XP.
Question: When the remote server application’s computer’s operating system changes from Windows 2000 to XP, why can the client remote application no longer connect? Solution: This happens because usually Windows…
KB-17086: Message: “This resource is not available for this version of Elipse SCADA”.
Question: When I click Databases via Organizer, the following message is displayed: “This resource is not available for this version of Elipse SCADA “. Why does this happen? Solution: This…
Demo application: Changing values in a historic via browser.
Application that uses a historic as a database, where data can be altered via browser. Attachments: editrecordEN.zip
Demo application: Deleting records from a batch.
Application that illustrates how to delete records from a batch. Attachments: batch_EN.zip
KB-31640: Storing data about users and passwords.
Question: Do I need to use a database to create a registry system in the application? Solution: No. There is already a proper place in Elipse SCADA to store information…
Demo application: Elipse SCADA interaction with a database via ODBC connection.
You can use an ODBC connection to export/import/change data from an external database’s table via Elipse SCADA. In the attached demo application, there are connections for Microsoft Excel 97, Microsoft…
Demo application: Understanding how batch historics work.
This application shows how batch historics, that is, historics that enable indexing a series of records to another record, work. The historic only starts recording data when a batch starts.…