Using Databases in E3: Chapter 5 – Inserting Records.
There are two ways to insert new records in a database in addition to using native E3 objects: via a Query or via scripts. If record insertion is performed via…
Author: Elipse Software
Using Databases in E3: Chapter 6 – Editing Records.
To edit a record of the Historic, you must use the UPDATE clause. This is the SQL code structure. UPDATE (function used) TABLENAME (table used) SET FIELDNAME2 (field of the…
Using Databases in E3: Chapter 7 – Deleting Records.
Records can be deleted in two ways: by filter, or by all existing records. To delete only one or more records of a database table, you must configure the SQL…
Using Databases in E3: Chapter 8 – Common Problems.
Why are .e3i and .e3o files too big? These files are temporary buffers, which are not usually noticed by the user of the system. When they grow in size, this…
Using Databases in E3: Chapter 3 – Inserting a Historic.
In order to send records to a database, you must insert a Historic object. A tutorial for creating Historics can be found in the article http://kb.elipse.com.br/pt-br/questions/123. Figure 1: Inserting a…
Using Databases in E3: Chapter 4 – GetADORecordset.
The Query’s GetADORecordSet method returns a Recordset object of type ADO (ActiveX Data Object), the result of executing the configured query. The ADO RecordSet object is used to access records…
Using Databases in E3: Chapter 2 – Connection with the Database.
To establish a connection with a database in E3 using the Organizer, first you must create a Database object, according to the following figure: Figure 1: Inserting a Database object…
KB-41276: Buscando arquivos passando um trecho do nome como parâmetro.
Descrição Quero usar a função FindFirstFile para buscar um arquivo, passando como parâmetro apenas um trecho do nome do arquivo. É possÃvel? Solução Sim, basta usar um asterisco (*). Exemplo…
KB-38180: Changing a driver’s serial port at run time.
Question: Can the serial port set up in a driver be edited at run time? Solution: Yes. To do so, you must edite the IO.Serial.Port tag. To force the IOKit…
Using Databases in E3: Chapter 1 – Choosing the Database.
Choosing a database directly depends on its purpose. Next, there is a comparison among the advantages and disadvantages of the available database. Access Advantages Fast for small databases; Simple configuration.…