Category: Elipse E3

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…

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.

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?…

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…

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…

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…

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…

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…

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…