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

SQL Editor

The SQL Editor allows to write Select statements. For this, all tables or querys, bound to the project, can be used in the statement.

Fig. 37: SQL Editor
Fig. 37: SQL Editor

Database fields can be combined with other database fields or with strings by the & character.

Example:

Select ID & ' , ' & STATE AS STATEID from ADDRESS

Edit SQL Statement Edit SQL Statement