Categoria:

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…

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