Welcome to our knowledge base. To find what you're after, use the search box below or choose a category to view listed articles.
View Articles by Category
There are no sub categories
Category » DataBases
There were 6 articles found in this category:
KB-18174: Elipse SCADA and Oracle database
Question: Can Elipse SCADA record data in an Oracle database? Solution: To do so, just perform the connection to the database by the Control Panel\Administrative Tools.
- KB-15128: Deleting a record in the database
Question: Which function must I use to delete a record in a database? Solution: To do so, you must use the DeleteRecord() function.
- KB-37267: Converting Excel's table into DAT file
Question: How can I convert an Excel's table into a DAT file? Can I convert the table using a by-date filter? Solution: To do so, you must write a script. Check the attached example application for more information.
- KB-35855: Connecting SCADA to the SQL Server
Question: Can I connect SCADA to the SQL Server? Solution: Yes, you can. To do so, you must use an ODBC connection. Check for more information on the attached document (in Portuguese).
- KB-29699: Historic files extensions
Question: In which files are the Historic data stored? Solution: They are stored in the .Dat and .Batch files of SCADA itself. .Dat - It is data itself; .Batch - it is the header, if it is a batch-type Historic.
- KB-33320: SQL Server’s query filter in SCADA
Question: How can I create a filter for an SQL Server's query with an ODBC connection? Solution: To do so, you must use table's SQLQuery() function. Records can be selected with functions such as MoveNext, MovePrev, etc, and filters can be accessed directly via AppBrowser. Examples of filters: S ...