Filter
Top Products
CHAPTER 4 Defining DataWindow Objects
DataWindow Designer User’s Guide 145
3 Select the object you want.
DataWindow Designer opens the DataWindow painter and displays the
DataWindow object. You can also open a DataWindow object by double-
clicking it in the System Tree.
To learn how you can modify an existing DataWindow object, see Chapter
5, “Enhancing DataWindow Objects.”
Defining queries
A query is a SQL SELECT statement created in the Query painter and saved
with a name so that it can be used repeatedly as the data source for a
DataWindow object.
Queries save time, because you specify all the data requirements just once. For
example, you can specify the columns, which rows to retrieve, and the sorting
order in a query. Whenever you want to create a DataWindow object using that
data, simply specify the query as the data source.
❖ To define a query:
1 Select File>New from the menu bar.
2 In the New dialog box, select the Database tab.
3 Select the Query icon and click OK.
4 Select tables in the Select Tables dialog box and click Open.
You can select columns, define sorting and grouping criteria, define
computed columns, and so on, exactly as you do when creating a
DataWindow object using the SQL Select data source.
For more about defining the
SELECT statement, see “Using SQL Select” on
page 121.