Como personalizar o PowerExplorer.
O PowerExplorer é uma ferramenta que lista automaticamente todas as medidas analógicas e discretas de um equipamento, bem como também todos os seus comandos e proteções, sem a necessidade de…
Search Results for: logs
Hands-Off Mode: Propagando arquivos PRJ e LIB via DFS.
A partir da versão 4.5 Build 228, o E3 possui um recurso chamado Hands-Off Mode. Esta ferramenta permite abrir os arquivos de projeto (.PRJ e .LIB) no modo hands-off, possibilitando…
Structure Query Language (SQL): Chapter 9 – Stored Procedures.
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…
Structure Query Language (SQL): Chapter 7 – Views.
A view is an alternative solution for observing data from one or more of the tables comprising a database. You can regard it as a virtual table or a stored…
Structure Query Language (SQL): Chapter 8 – Triggers.
Triggers are a type of special stored procedures that are executed whenever there is an attempt to change the data in a table protected by them. DML triggers (Data Manipulation…
Structure Query Language (SQL): Chapter 4 – Backup.
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…
Structure Query Language (SQL): Chapter 6 – SQL Commands.
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…
Structure Query Language (SQL): Chapter 5 – Best practices for setting up Historics and Queries.
Historics are the modules responsible for storing application data in a Database for further analysis. You can create as many Historics as needed, each containing several Tags or expressions. Each…
Structured Query Language (SQL): Introduction.
This is the introduction to a series that will discuss SQL, the widely known language used for relational databases. The Structured Query Language (SQL), a very popular one for interacting…
Structure Query Language (SQL): Chapter 1 – Manipulating information in the DB.
Basically, information can be manipulated in the Database in three different ways: DML – Data Manipulation Language Statements: INSERT, UPDATE, DELETE, SELECT DDL – Data Definition Language Statements: CREATE, ALTER,…