KB-31877: Creating tables.
Question: Should a data structure be created beforehand (for example, a table in the SQL Server) so that I can start working with the Database in E3? Solution: Not necessarily.…
Question: Should a data structure be created beforehand (for example, a table in the SQL Server) so that I can start working with the Database in E3? Solution: Not necessarily.…
Tanto o EPM Studio quanto o EPM Add-In para o Excel utilizam grids para busca e apresentação de Data Objects (tags) do EPM, com a possibilidade de filtros. Esses filtros…
Question: How can I return all the tables existing in an Access, Oracle, or SQL database? Solution: To do so, follow the procedures below according to the database type. Access…
Question: What can cause an Oracle database to run slower (in Queries or when inserting and deleting data), and yet not presenting any other apparent errors? Solution: This could be…
This article illustrates how to install and set up the SQL Server Express 2005, free version of Microsoft’s database, and use it as E3’s database. The installer can be downloaded…
Question: Why are _Sync.e3i and _Sync.e3o files being created in the application folder of the computer running E3? Solution: These files contain database operation queues that are being synchronized between…
Question: How can I set up an Oracle database in the same computer running E3Server? Solution: To do so, just leave Connection field blank in the database settings. You will…
Question: How can I connect to an INFOMIX database via scripts? Solution: To connect to an INFOMIX database via scripts, you can use the following methods: Set DBConnection = CreateObject(“ADODB.Connection”)…
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…
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…