17. SQL definitions

Image sqldefe

The SQL definitions described here serve the purpose of providing users with specific record selections at start-up. The name of the SQL definition must be AVSTART in all cases.

The individual fragments must be separated by a space each and are to be used in the sequential order described below.

SELECT * FROM Table WHERE (Conditions) ORDER BY (Sort)

Image tip The underlined part of the SQL fragment must not be entered. It will be added automatically when the system carries out the initial selection.

(Conditions): The conditions serve to restrict the selection of records. You can use the ('%') sign as wildcard symbol, however, you must use it according to SQL standard. Leaving away the condition 'WHERE' would result in all records being selected.

(Sort): After the fragment 'ORDER BY' the field names follow according to which the sorting takes place. You can use several fields. The abbreviations 'ASC' and 'DESC' result in ascending and descending sorting, respectively. 'ASC' is optional, i.e. when nothing is mentioned an ascending sorting is effected. If you omit the condition 'ORDER BY', no sorting will take place.

Example:

Laufnummer > 0 ORDER BY Datum DESC, Laufnummer DESC