Question: How can I copy data from an Excel spreadsheet to an Access database? Solution: There are two possibilities: At runtime: With a script using an ADO connection to access…
Question: How can I set up an SQLExpress database in an E3 application? Solution: To do so, you must first install the SQLExpress in a PC, create a database, and…
Question: How can I access (directly in the database and not via E3) the Stored Procedures E3 has created with Storage in Oracle? Solution: The Stored Procedures are in the…
Question: I have configured a database with SourceType property as 2-stSqlServer, and set up a user and a password according to the SQL Server. When I add a query to…
Question: How can I tell whether the remote database is available when the network is down? Solution: To do so, use a script to test the Database’s ConnectionAtive property. However,…
Question: What Databases are supported by E3? Solution: E3 is natively connected to Access, Oracle, SQL Server, PostgreSQL and MySQL.. However, if you want to connect to another database, this…
Question: How can I exclude a record from the database from a selection in an E3Browser on the application’s screen? Solution: To delete the record, you can use a Query…
Question: In a 64-bit server, I have a 32-bit E3 and a 64-bit Oracle Client installed. When I test their connection in E3Studio, the following message pops up: It…
Question: How can I split the screen in four spaces, each showing a different screen? Solution: To do so, split a Frame in four. On each splitter, set up SplitLink…
Question: Where can I set up the message shown in displays whenever there is a communication error? Solution: You can do that at Text option on Communication Errors tab, Viewer…