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:
-
Select File>New from the menu
bar. -
In the New dialog box, select the Database tab.
-
Select the Query icon and click OK.
-
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”.