KB-31974: Databases: comparing models.
ACCESS Pros: Microsoft Office Professional Fast for small databases Simple settings Stores data from both SQL and Oracle VBA (Visual Basic for Applications) language and SQL Import/export tools (Windows) Cons:…
KB-64893: Relatório que mostre valores que excedam 24 horas.
Descrição: Como posso formatar o campo de dados do relatório para que ele mostre valores de hora superiores a 24 horas, já que a formatação [h]:mm:ss não mostra os valores…
KB-64642: Configuração dos parâmetros ‘NetWork number’ e ‘PC number’ do driver Melsec-Q.
Descrição:Como configurar os parâmetros NetWork number e PC number do driver Melsec-Q da Mitsubishi? Solução:Os parâmetros NetWork number (número da rede do dispositivo remoto) e PC number (número do PC do…
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.…
Usando filtros nos grids do Elipse Plant Manager.
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…
Returning all tables existing in a database.
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…
KB-32929: Slowness in Oracle databases.
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…
SQL Server Express 2005 Tutorial: installation and settings.
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…
KB-15057: *_Sync.e3i an *_Sync.e3o files alongside the application.
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…
Formatting values that contain zeroes to the left.
Question: How can I format a value containing zeroes to its left and then later save it in a historic? Solution: To add zeroes to the left, use the following…