Você pesquisou por databases - Elipse Knowledgebase

Migrating Access databases to SQL Server 2017.

13 de August de 201914 de August de 2019Henry Vieira da SilvaLeave a Comment

This article will show you how to migrate an Access database to SQL Server 2017. To do so, just follow the instructions below: First, copy the Access database. Soon after,…

Recording alarms in different databases and tables.

25 de March de 201929 de May de 2019Enrico Busnello AmorimLeave a Comment

Question: Can I create multiple alarm servers in an E3 application? If not possible, can two alarms be saved in two databases at the same time via Alarm Server? Solution:…

Data compression algorithms in process historians with commercial databases.

25 de March de 20194 de July de 2019Elipse SoftwareLeave a Comment

1) INTRODUCTION The constant need for improvement in productive processes, including the pressure for lower costs and shorter deadlines, requires us to have increasingly more information about everything taking place…

KB-31974: Databases: comparing models.

25 de March de 20195 de July de 2019Elipse SoftwareLeave a Comment

ACCESS Pros: Microsoft Office Professional Fast for small databases Simple settings Stores data from both SQL and Oracle VBA (Visual Basic for Applications) language and SQL Import/export tools (Windows) Cons:…

KB-32929: Slowness in Oracle databases.

25 de March de 20195 de July de 2019Elipse SoftwareLeave a Comment

Question: What can cause an Oracle database to run slower (in Queries or when inserting and deleting data), and yet not presenting any other apparent errors? Solution: This could be…

KB-33906: Hot-Standby x Databases.

25 de March de 201911 de September de 2019Elipse SoftwareLeave a Comment

Question: What is the proper architecture to work with databases in Hot-Standby? Solution: There are two possibilities: Two computers running E3Server (Hot and Standby), and a third one running the…

Using Databases in E3: Chapter 5 – Inserting Records.

25 de March de 201927 de June de 2025Elipse SoftwareLeave a Comment

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…

Using Databases in E3: Chapter 6 – Editing Records.

25 de March de 201914 de January de 2022Elipse SoftwareLeave a Comment

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.

25 de March de 20197 de March de 2023Elipse SoftwareLeave a Comment

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.

25 de March de 201922 de January de 2020Elipse SoftwareLeave a Comment

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…