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

Edit SQL Statement

The SQL Editor provides several editor pages to edit SQL Statements. It will be provided by opening .sql files.

The following buttons will be displayed in the eclipse toolbar:
Tabelle hinzufügen Adds a new table in the Visual Editor
Tabelle entfernen Deletes the selected table in the Visual Editor
Tabellenspalte hinzufügen Adds a new column in the Column Editor
Tabellenspalte entfernen Deletes the selected column in the Column Editor
Abfrageeigenschaften Opens the Query Properties dialog
Tabelleneigenschaften Opens the Table Properties dialog for the selected table
Verknüpfung entfernen Deletes the selected link
Verknüpfungseigenschaften Opens the Link Properties dialog
Funktionen Anzeigen Displays the column Function in the Column Editor
Parameter Auswahl Settings for the Parameter assignmentsthat are placeholders for data formats and Variables
Erste Seite Displays the first 200 data records in the Dataviev
Vorherige Datensätze Displays the previous 200 data records in the Dataviev
Nächste Datensätze Displays the next 200 data records in the Dataviev
Letzte Seite Displays the last 200 data records in the Dataviev
Datensätze Filtern Establishes the filters forthe data records (s. Filter Records)

SQL Statement SQL Statement
SQL Editor SQL Editor
Visual Editor Visual Editor
Results Results
Link Properties Link Properties
New Link New Link
Parameter Assignment Parameter Assignment
Query Properties Query Properties
Table Properties Table Properties