Quick Select dialog box
Description
In the Quick Select dialog box, you can choose columns from
one table or from multiple tables if they are joined through foreign
keys. You can sort the columns and specify retrieval criteria.
When to choose SQL Select instead
You cannot specify retrieval arguments, computed columns,
or grouping using Quick Select. To set these things, start the painter again
and use SQL Select instead or proceed and then choose Design>Data
Source in the painter.
Dialog options
-
Tables
If you select a table, the view changes to display only tables
related via a foreign key. Click on the table again to deselect
it and return to the full list. -
Columns
Displays all the columns in the currently selected tables. The
columns you select for the DataWindow or Data Pipeline appear in
the Sort/Criteria grid at the bottom. -
Add All
Selects all the columns in the Columns box for the DataWindow
or Data Pipeline and adds them to the Sort/Criteria grid
at the bottom. -
Sort/Criteria
Specifies how columns will appear and how data will be selected
and sorted from the database.Option
Action
Change column order
Drag a column head to a new position
Change a column’s initial width
Drag the column’s edge
Choose a sort order for a column
In the column’s Sort cell, click
to display the Sort dropdownSpecify selection criteria for a column
In the column’s Criteria or
Or cell, specify an expression using any SQL relational operatorExpressions in the same row but for different columns are
joined with logical AND. Expressions in the second row are joined
with first-row expressions with logical OR