Fig. 38: Visual Editor
The editor page Visual Editor allows the simple design of SQL statements.
Tables can be dragged from the Navigator view into the Visual Editor by Drag & Drop. To link the tables, the desired columns can be connected by Drag & Drop. The dialog Link Properties kan be opened by double click on the link line
The several columns can be added to the Column Editor in the lower part of the SQL Editor by double click on the columns in the upper part of the editor.
| In the Column Editor the following settings can be made: | |
|---|---|
| Show | Defines whether the column will be visible in the result. This is e.g. usefull for criterias when the column is not needed in the result |
| Field | Defines the desired column |
| Table | Defines the desired table |
| Sort | The result will be sortedascending or descendingby the content of the column |
| Criteria | The criterias of the Where-Clause to restrict the result of the query. E.g.: < 40 and > 20 at house numbers will result in where person.Hausnummer < 40 and person.Hausnummer > 20 in the statement |
| Or | The or columns can contain additional criterias that are combined by the logical Oroperator |
The order of the columns can be changed in the Column Editor by Drag & Drop.
Edit SQL Statement