Skip to content

Elipse Knowledgebase

  • Home
  • English (US)English (US)
    • Português do BrasilPortuguês do Brasil

Category: DataBases

KB-27260: Backing up a database with E3.

25 de March de 20195 de July de 2019Elipse SoftwareLeave a Comment on KB-27260: Backing up a database with E3.

Question: How can I back up a database via E3? Solution: To do so, there are two possibilities: 1. In an Access database, copy the file corresponding to the database…

Read More

KB-30261: Using an SQL 2005 Express database.

25 de March de 20195 de July de 2019Elipse SoftwareLeave a Comment on KB-30261: Using an SQL 2005 Express database.

Question: How can I establish communication between E3 and SQL 2005 Express ? Solution: To do so, add a database to E3, access its properties, and set it up as…

Read More

Database Servers: Introduction.

25 de March de 20195 de July de 2019Elipse SoftwareLeave a Comment on Database Servers: Introduction.

Question: What is a Database Server? What is it for? Solution: A DBServer, or a Database Server, is the application item that concentrates all the project’s data records and queries…

Read More

KB-31829: Remote recording in Oracle/SQL Server.

25 de March de 20195 de July de 2019Elipse SoftwareLeave a Comment on KB-31829: Remote recording in Oracle/SQL Server.

Question: Can data be recorded in a remote Oracle or SQL Server? Solution: Yes; to do so, you must just enable the Oracle/SQL Server to accept remote data recording.

Read More

KB-30971: Changing database type.

25 de March de 20195 de July de 2019Elipse SoftwareLeave a Comment on KB-30971: Changing database type.

Question: If an application starts with an Access database and in the middle of the process it migrates to SQL/Oracle, will the previous data be sent to the new database?…

Read More

KB-31698: Number of SQL clients required in an E3 application.

25 de March de 201910 de June de 2019Elipse SoftwareLeave a Comment on KB-31698: Number of SQL clients required in an E3 application.

Question: How many SQL client licenses are required in an application with two E3Servers (in Hot-Standby) and five Viewers? Solution: The communication between E3 and the database happens exclusively in…

Read More

KB-26755: Access database and application performance.

25 de March de 20195 de July de 2019Elipse SoftwareLeave a Comment on KB-26755: Access database and application performance.

Question: My application’s got slower after two weeks working with an Access database. Why has this happened, and how can I fix it? Solution: This may have happened because the…

Read More

Structure Query Language (SQL): Chapter 9 – Stored Procedures.

25 de March de 201912 de February de 2020Délio DaminLeave a Comment on 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…

Read More

Structure Query Language (SQL): Chapter 7 – Views.

25 de March de 201912 de February de 2020Délio DaminLeave a Comment on 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…

Read More

Structure Query Language (SQL): Chapter 8 – Triggers.

25 de March de 201912 de February de 2020Délio DaminLeave a Comment on 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…

Read More

Posts navigation

Previous 1 … 3 4 5 … 13 Next

Categories

Search by Category

© 2025 Elipse Knowledgebase | Elipse Software - Todos os Direitos Reservados.