KB-31207: Commands to insert, edit, and delete records in a database.
Question: How can I insert, edit and delete records of a database via E3? Solution: Via E3Studio, access the Query’s properties and then, on SQL tab, enable SQL’s edition option,…
Category: DataBases
KB-39000: Adding a record into a PostgreSQL Database.
NOTE: From Elipse E3 version 6.5 on, the supervisory has featured native connection to PostgreSQL. This article applies to versions prior to 6.5. Question: How can I add a record…
KB-38947: Creating a Historic field that automatically increments its value
Question: How can I create a Historic field that automatically increments its value, so that when there is a new record, it receives a sequential value? Solution: It is not…
KB-30529: Error 80004005 when accessing Access database.
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…
KB-36672: Rounding decimal places when saving values in a Database.
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,…
KB-27358: Databases vs. Tables vs. Fields.
Question: In an application, I need to record the values of 25 variables in an Access database to be loaded by an E3Chart. Which of the options below is the…
Saving the content of a Database’s table in a text file.
Question: How can I save a Database’s table in a text file? Solution: To do so, you can create a Report, configure a Query, and use the Export() method; or…
KB-29591: Generating SQL Database backup via E3.
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…
KB-32156: Using indexes and primary keys with Insert, Delete, and Update commands.
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,…
KB-27883: Copying registers from Access to Oracle.
Question: How can I copy the alarms being recorded on an Access Database to the Oracle? Solution: To do so, you must use a Query object on the Data Server…