Category: DataBases

Question: How can I make a series of I/O tags display 0 whenever they return with a negative value (i.e., below zero), so as to make it possible their being…

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

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

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

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…

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”)…