The easiest way to define a data source is using Quick Select.
To define the data using Quick Select:
-
Click Quick Select in the Choose Data Source dialog box in the wizard and click Next.
-
Select the table that you will use in the DataWindow object.
For more information, see Selecting a table.
-
Select the columns to be retrieved from the database.
For more information, see Selecting columns.
-
(Optional) Sort the rows before you retrieve data.
For more information, see Specifying sorting criteria.
-
(Optional) Select what data to retrieve.
For more information, see Specifying selection criteria.
-
Click the OK button in the Quick Select dialog box.
You return to the wizard to complete the definition of the DataWindow object.
Quick Select limitations
When you choose Quick Select as your data source, you cannot:
-
Specify grouping before rows are retrieved
-
Include computed columns
-
Specify retrieval arguments for the SELECT statement that are supplied at runtime.
To use these options when you create a DataWindow object, choose SQL Select as your data source. If you decide later that you want to use retrieval arguments, you can define them by modifying the data source. For more information, see Enhancing DataWindow Objects.
