KB-27205: SQL query execution retrieval via E3.
Question: How can I tell whether a query’s DELETE command was successfully sent to the database? Solution: To do so, you can use the return of query’s EXECUTE command to…
Category: English
KB-28857: Opening screens when tags change their values
Question: How can I open a screen in a splitter whenever a tag changes its value? Solution: To do so, you must create a user event in the Viewer whose…
KB-28700: Informing the Remote Viewer that the application has been altered in the Server.
Question: How can I inform the Remote Viewer that the application has been altered in the Server? Whenever an application is edited and updated in E3Server, the Viewer is only…
KB-14572: Error: Table structure can’t be generated in the Database.
Question: After configuring the fields, the data server (Access), and table name in a historic, I click Generate Table and the following error message is displayed: Table structure (title of…
KB-28705: Error when executing a connection to Oracle database via scripts when Oracle Client is not installed.
Question: When I open the Viewer or WebViewer and click on a button that executes a script to query an Oracle database, a connection error to the database is generated.…
KB-19208: Copying data from an Excel spreadsheet to an Access database.
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…
KB-19505: Setting up an SQLExpress database in an E3 application.
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…
KB-15588: Accessing E3-generated StoredProcedures in the database.
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…
KB-12455: Error: Table structure can’t be generated in the Database.
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…
KB-29668: Retrieving database status.
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,…