2012

To open the Query Editor
1 Click Tools menu ➤ Palettes ➤ dbConnect.
2 In the dbConnect Manager, in the tree view, select a database table.
3 Click the New Query button.
4 In the New Query dialog box, enter a name for the query in New Query
Name.
5 Click Continue to open the Query Editor.
To construct a query with a single parameter on the Query Builder tab
1 Open the Query Editor.
2 On the Query Builder tab, select a field from the drop-down list in the
Field cell.
3 Select an operator from the Operator cell drop-down list.
4 Enter a value in the Value cell, or click the [...] button.
The [...] button returns a list of all values for the specified field from the
database table, allowing you to select the value you want. After selecting
a value, click OK.
5 If you want to save the query in the current drawing for future use, click
Store.
6 Click Execute to execute the query and close the dialog box.
2038 | Chapter 39 Access External Databases