Filter
Top Products
Defining queries
146 DataWindow .NET
Previewing the query
While creating a query, you can preview it to make sure it is retrieving the
correct rows and columns.
❖ To preview a query:
1 Select Design>Preview from the menu bar.
DataWindow Designer retrieves the rows satisfying the currently defined
query in a grid-style DataWindow object.
2 Manipulate the retrieved data as you do in the Database painter in the
Output view.
You can sort and filter the data, but you cannot insert or delete a row or
apply changes to the database. For more about manipulating data, see
Chapter 3, “Managing the Database.”
3 When you have finished previewing the query, click the Close button in
the PainterBar to return to the Query painter workspace.
Saving the query
❖ To save a query:
1 Select File>Save Query from the menu bar.
If you have previously saved the query, DataWindow Designer saves the
new version and returns you to the Query painter. If you have not
previously saved the query, DataWindow Designer displays the Save
Query dialog box.
2 Enter a name for the query in the Queries box (see "Naming the query"
next).
3 (Optional) Enter comments to describe the query,.
These comments display in the Library painter. It is a good idea to use
comments to remind yourself and others of the purpose of the query.
4 Specify the library in which to save the query, and click OK.