The Select painter has a new tab dialog.

To specify sort criteria:

1. Click the Sort tab. The Sort definition dialog displays. The names of the columns you selected for the SELECT statement display in the box below the Sort tab.
2. Click the first column on which you want to sort and drag it to the window on the right.
3. Drop the column. When you drop the column, a checkbox labeled Ascending displays. By default is it checked to indicate the column will be sorted in ascending order. Uncheck it to sort in descending order.

Tip       The columns are sorted in the order in which they display in the window on the right. To change the sort order, drag the column names into the desired order.

4. Define Where, Having, or Group By criteria, or click the Return icon to return to the painter from which you opened the Select painter.

To specify WHERE criteria:

1. Click the Where tab. The Where criteria definition dialog displays.
2. Click the first row under Column or click the right mouse button and then select Columns from the popup menu. The names of the columns you selected for the SELECT statement display.
3. Select the column you want to use in the first expression of the WHERE criteria.

Tip       To use a function in the first expression, select Functions from the popup menu.

If you have defined retrieval arguments for the statement, you can specify a retrieval argument as the first expression in the WHERE clause. To do so, select Arguments from the popup menu.

4. Enter the operator you want or click the Operator column to display the list of operators and then select the operator.
5. Specify the value for the WHERE criteria. You can specify a literal or you can specify a column, function, or retrieval argument. To select a column, function, or retrieval argument, click the right mouse button in the Values window to display the popup menu.
6. (Optional) Select a logical operator (AND or OR). To select a logical operator, click in the column under the heading logical. A dropdown listbox lists the logical operators. Select the operator you want.
7. Repeat step 6 until the definition of the WHERE criteria is complete.
8. Define Sort, Having, or Group By criteria, or click the Return icon to return to the painter from which you opened the Select painter.

To specify Group By criteria:

1. Click the Group tab. The Group criteria definition dialog displays.
2. Select the column you want to be the first grouping item and drag it to the box on the right.3
3. Drop the column.
4. Repeat if you want to create a group within the first grouping item. The items are grouped in the order in which you select them and the number of items in each group should become progressively smaller.
5. Define Sort, Having, or Group By criteria, or click the Return icon to return to the painter from which you opened the Select painter.

To define Having criteria:

1. Click the Having tab. The Having criteria definition dialog displays.
2. Follow the steps outlined above for defining Where criteria.

To define a computed column:

1. Click the Compute tab. The expression definition dialog displays.
2. Paint the computed column expression. Click the right mouse button to display the popup menu. Select the columns, functions and arguments you want to use in the expression for the computed column.
3. Define Sort, Having, Where or Group By criteria, or click the Return icon to return to the painter from which you opened the Select painter.