| Name of the query. |
| Display name of the query (shown
in the column of
the work area for master data). |
| Pre-configured
connection to the database. |
| Lists all tables available in the selected
database. |
| Indicates how searches are performed.
If is selected, these wildcards can be used in the search expressions: or % | Zero or more characters. Example search of names: ROB* or ROB% returns all data sets in which Name begins with ROB. | | One character. Example search of names: ROB?ER* returns all data sets in which Name begins with RO, followed by any single character, followed by ER, followed by zero or more characters. |
|
| Indicates which query results are returned.
: All search
results are returned. : A search
result is returned only if it is unique. : Only the
first result is returned.
|
| Maximum number of the returned results.
If the query returns more results than the number specified here,
only this specified number of results are returned. (This increases
performance.) |
| If selected, duplicate entries in the
database are searched. If not, they are ignored. |
| These options mark the corresponding checkboxes in all rows below. |
Settings per column | : Name of the
table column. : Name of
the table column in the dialog. : The XBOUND-compliant
data type of the column. : Indicates whether
the table column is displayed in the dialog. : Indicates whether
the value of the table column is to be transferred into the
assigned XBOUND field or cell. : Indicates whether
the value of the XBOUND field or cell is to be used for filtering
this table column (WHERE clause). :
Assignment of XBOUND fields/table columns to the database
table columns. You can type the name of a field, a field group,
or a table column here. The system suggests values that match
what you typed (though you do not need to use them). When
the query is executed, the system searches for a field by
this name in the current document. Syntax: : Field name
: Field
group name followed by a period (.) and the field name.
Example: InsuranceData.FirstName. Can be nested in different
levels. : Table
name followed by a greater-than sign (>) and the column
name. Example: Positions>Articlenumber.
: Type a value
here for testing the query. This value is not stored.
|
button
| Checks the query settings specified in
this dialog and saves them. The query is executed using the entered
test values, and the results are displayed in the dialog. If the or
columns are activated, an XBOUND field must be assigned. If one of the displayed queries is incorrectly configured, the
incorrect property is highlighted in red. This can happen if the
field definition that is used in the query has been deleted, for
example. |
To
access this dialog:
).