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 https://kb.elipse.com.br/pt-br/questions/123. Figure 1: Inserting a…
Question: Even when configuring a SQL Server database as ComputerName\SQLEXPRESS, there is a need to repeat this configuration every time the machine changes. Is it possible to set up the…
Question: How can I insert a record into a PostgreSQL Database? Solution: To do so, you must create the connection via scripts, since this Database is not native to E3.…
Question: When testing the connection to an Access database, the error 80004005 is displayed. How can I fix this? Solution: To do so, check if the *.mdb file path is…
Question: How can I round the decimal places of the variables’ values when saving them in a Database? Solution: This is not recommended, but if you want to do it,…
Question: How can I generate backup for the Database recorded in the SQL Server via E3? Solution: To do so, you must access E3Studio, create a Query linked to the…
Question: What is the effect of using indexes and primary keys in Insert, Delete, and Update commands? Solution: When using an index or a primary key in the Insert command,…
Question: In a HotStandBy application with two databases to record the same data (one in the main computer, and another one in the secondary computer), is there synchronism between DBs?…
Question: Why is thre an authentication error when I try to establish connection with an MS SQL Server database? Solution: To fix this, you must use the MS SQL Server’s…
This article illustrates the necessary settings to enable remote access to SQL Server Express 2005. 1. Go to Start–All Programs–Microsoft SQL Server 2005–SQL Management Studio Express and follow the instructions…