Demo application: Printing a formatted report using a query.
This application illustrates how to print in a formatted report of a query to a historical file. Attachments: 5243.zip
Author: Elipse Software
KB-31347: Calculating a historic tag’s average inside a start/end date/time range.
Question: How can I calculate a historic tag’s average inside a start/end date/time range? Solução: To do so, use Average function. Average (src, type, startTime [, endTime]) This function returns…
Size limit in an Elipse SCADA historic file (*.dat).
Question: How large is an Elipse SCADA’s historic file (*.dat)? Solution: Elipse SCADA’s historic files are no larger than 2GB. Their records’ limit, even when the configured value is high,…
KB-33835: Calculating a historic file’s (*.dat) size.
Question: How can I calculate how much space a historic file will occupy in the hard disk? Solution: To do so, consider this: File header: 24 bytes. For each field,…
KB-28134: Deleting records from a historic.
Question: How can I delete records from a historic? Solution: To do so, use the ClearHistoricalData() function of the desired historic (via scripts). If there is any object using the…
With the application running, I can’t access the Database.
Question: When Elipse SCADA is open, why can’t I open the linked database? Solution: The database opening mode via ODBC connection is usually exclusive, that is, it prevents the simultaneous…
KB-28035: Message: “The DAO.dll file was not found”.
Question: After having formatted the computer and correctly installed Elipse SCADA, the application being executed displays the following error message: “The DAO.dll file was not found “. How can I…
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…
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…