A stored procedure is a set of instructions developed in T-SQL language (Transact-Sql) that, whenever stored or saved, are inside the server in a pre-compiled way. This procedure is stored…
OpenOffice can establish a DDE connection, where you can read data via Elipse SCADA. According to the software’s documentation, to do so you will need to insert the following paramenters:…
The main task in a Database manager is to not just make sure all data is inserted, but also that these data continue existing. Regardless of the contingency system, the…
O OpenOffice possui conexão DDE, onde é possível ler dados através do Elipse SCADA. Conforme documentação do software, para isto basta inserir os seguinte parâmetros: Nome do servidor: soffice Tópico:…
This article illustrates a few SQL commands. To illustrate how they are used, the following tables will work as reference: Store_Information table: Store_Name Sales Date_Time Los Angeles 1500 05-Jan-1999…
To create a cumulative sum of a table field, you can set up a Query with SQL’s Inner Join command. Example: Date/Hour Field Accumulated 20/02/2014 09:54:05 1 1 20/02/2014…
Question: How can I count the number of lines in a TXT file? Solution: To do so, you must use the methods in FileSystemObject object. Example: ‘Script for returning lines…
Question: How can I return the contents of a specific line in a TXT file? Solution: To do so, you must use the methods in FileSystemObject objects. Example: Const ForReading…
Many times, a chart report must be exported automatically, with no intervention from the operator. Therefore, the Report’s Chart object must be set up so that data is moved correctly,…
Question: In an application, the behavior of a Historic linked to IOTags is odd: Values are recorded as soon as the application starts running, even though it is set up…