Selecting Displayed Fields with SQLWizard

Use the Select Fields to Display dialog to select the data columns that are displayed in your Query results and to select the order in which the data is displayed.

To select the fields for display:

1    In SQLWizard, click Show Fields. The Select Fields to Display dialog is displayed.

2    To add a field to the display, select its entry in the Available fields list, click Add and select a display option in the drop-down list. The field is added to the Displayed Fields list.

3    If you want to change the order in which the field is displayed, click on the row selector at the left of the field, and, holding the mouse button down, drag the field to its new position.

4    If you want to use the field to control the sort order in which the data is displayed:

a    Right-click the entry in the Displayed Fields list and choose Sort result field from the shortcut menu. The field is displayed in the Sorted fields list.

b    In the Sorted fields list, right-click the Sorting type column of the field and choose a sort order from the shortcut menu.

5    If you want to remove a field from the Displayed Fields list, right-click the field and choose Delete result field from the shortcut menu.

6    Click OK to save your changes and close the window.