SQL Statement

SQL statements are an easy way to generate database table queries. These queries can be used in forms and they are often used for data overviews.

The eva/3 Application Builder visual editor creates SQL queries quickly, easily and is user-friendly. Queries can be modified in an SQL editor.

With the SQL-Editor, easy and quickly eva/3 Application Builder querys can be generated. Instead of the DSQL-Editor these querys can be generated independent from the database. Supported functions internal will be translated different depending on the database. So no database specific knowlege is needed.

Normaly the SQL Statements will be used as data source fotr forms or reports. In the instruction however not the table names of the data base are used, but the name of the file in the project directory without ending and path. These are loaded at executed, the actual table names are exchanged and the query will be converted into the data base-specific syntax.

So a simple creation of a database independent SQL Statement by the Visual Editor or by the Text Editor.

By using Variables, the queries can be varied on runtime. E.g. the results can be restricted depending of the entries in a form. It will be executed by the system command ExecuteSQLStatement

Working with Databases
Creating SQL Statements
SQL Statement Outline
Additional Informations
Edit SQL Statement