eva/3 Application Builder • Developing eva/3 Applications • Working with Databases • Database Views • Edit Databas View

SQL-Editor

Fig. 49: SQL-Editor

The following entries are available:
View name	Name of the database view in the database system
Connection file	The database connection file can be slected by clicking the button Search
Comment	Comment for the database view
SQL statement	Allows to enter the Create View statement

The Create View is to be created database specific and will not be translated by eva/3 Application Builder.

Example:

CREATE VIEW view_name (column_name1, column_name2, ..., ...) AS SELECT * FROM table_name ...

After a view is successfully synchronized with the database, the CREATE VIEW statement will be replaced by a corresponding ALTER VIEW statement.

Note:Because not every database system supports views, or does not support every keywords depending on views, the functionality of views is not provided for every database system.

Edit Databas View