Filter
Top Products
Using Quick Select
112 DataWindow .NET
Using Quick Select
The easiest way to define a data source is using Quick Select.
❖ To define the data using Quick Select:
1 Click Quick Select in the Choose Data Source dialog box in the wizard and
click Next.
2 Select the table that you will use in the DataWindow object.
For more information, see "Selecting a table" next.
3 Select the columns to be retrieved from the database.
For more information, see “Selecting columns” on page 114.
4 (Optional) Sort the rows before you retrieve data.
For more information, see “Specifying sorting criteria” on page 115.
5 (Optional) Select what data to retrieve.
For more information, see “Specifying selection criteria” on page 115.
6 Click the OK button 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 Chapter 5, “Enhancing DataWindow Objects.”