| General | |
| Sorting | Sets the correct sorting order (for example, how data is sorted within view tables or results lists when searching). |
| Result set type for update | If write access will cause any problems, select another result set type here. |
| Batch Updates use | You should keep this setting (yes ) for performance reasons. Only change this setting if any problems occur while saving data sets. |
| ORDER BY Alias support | 1) SELECT Field1 AS FieldAlias FROM Table1
TablesAlias ORDER BY TablesAlias.FieldAlias 2) SELECT Field1 AS FieldAlias FROM Table1 TablesAlias ORDER BY TablesAlias.Field1 SELECT Field1 AS FieldAlias FROM Table1 TablesAlias ORDER BY FieldAlias 3) SELECT Field1 AS FieldAlias FROM Table1 TablesAlias ORDER BY TablesAlias.Field1 Examples: Type 1) SQL Server Type 2) HSQL, SAP DB, Oracle Type 3) Access |
| Oracle 8 Syntax for Outer Joins | Oracle versions 8 and earlier use a different SQL syntax for OUTER JOIN queries than most other data bases. If a database uses the same syntax, please select yes |
| Clobs searchable | In this database, long text fields can be searched. This setting affects the search function. |
| Use driver Clob/Blob objects | For most databases you can enter no here. One of the few exceptions is Oracle. For performance reasons, it can sometimes be useful to use driver objects anyway. |
| Data Field Transformation | |
| Boolean Literal TRUE | Possible values: TRUE / true /
1 Normally TRUE is the correct selection. (Except: MS SQL Server, Oracle: 1) |
| Boolean Literal FALSE | Possible values: FALSE / false / 0 Normally FALSE is the correct selection.(Except. MS SQL Server, Oracle: 0) |
| Calendar is supported by date fields | Some databases do not support calendar objects for the query of date and time fields. This calendar object is necessary for calculation of the local time zone. Normally, no is the safest selection. |
| Date according to SQL | Formatierung eines Datumsobjektes für die Speicherung in der Datenbank via SQL Anweisung (%t ist der entsprechende Platzhalter, der vorhanden sein muss). |
| ISO Datumstext nach SQL | Formats a data object for saving it in the database via SQL command. (%t must be set as placeholder) ISO data text according to SQL Formats a string for saving it in the database via SQL command. (%t must be set as placeholder) |
| Large Objects (Clob / Blob) | |
| Clob method for empty Clob | Please read the documentation for the corresponding driver. Normally no entries have to be made and the fields cannot be selected. |
| Clob method for Writer | |
| Blob class for driver | |
| Blob method for empty Blob | |
| Blob method for Output stream | |