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…
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…
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…
Question: How can I connect the Viewer to a domain in another computer? Solution: To do so, you must execute the Viewer and, once the connection window is displayed, inform…
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…
Este artigo mostra como criar um sistema de troca rápida de telas, utilizando abas que são ativadas por uma passada de mouse. Vamos começar criando um Quadro no Viewer. Divida…
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.…
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…