eva/3 Application Builder • Developing eva/3 Applications • Working with Databases • Dynamic SQL Statements • Edit Dynamic SQL Statement 

SQL Editor

The SQL Editor allows to write SQL statements. These will not be translated by the execution. So the SQL dialect of the selected database must be used.

The SQLstatement can be executed by clicking the button SQL-Anweisung ausführen.

Fig. 46: SQL Editor
Fig. 46: SQL Editor

The following entries are available:
Connection file Contains the name of the database connection
Search Allows the selection of a database connection with the Document Selection dialog
SQL statement The SQL statement that should be executed

When e.g a Select statement is written in the Dynamic SQL-Editor, the results can be displayed on the editor page Results of the editor.

Edit Dynamic SQL Statement Edit Dynamic SQL Statement