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…
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,…
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…
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…
Descrição: Como posso contar o número de linhas contidas em um arquivo TXT?Solução: Para isto, deve-se utilizar os métodos do objeto FileSystemObject. Exemplo: ‘Script para retorno de linhas do arquivo TXTi…
Descrição: Como retornar o conteúdo de uma linha especÃfica de um arquivo TXT? Solução: Para isto, deve-se utilizar os métodos dos objetos FileSystemObject. Exemplo: Const ForReading = 1 Set fso = CreateObject(“Scripting.FileSystemObject”) Set f…
Access to Elipse SCADA’s database can happen via ISAM or ODBC sources. ISAM Connection ISAM is not supported by Windows x64, only x86, and as long as ISAM connection drivers…
1. INTRODUÇÃO A virtualização é a maneira mais eficaz de reduzir custos em TI de modo ágil e eficiente em empresas de qualquer tamanho, já que permite executar múltiplos sistemas…