Results Pane

See Also      Tasks

The Results pane shows the results of the most recently executed Select query. (The results of other query types are displayed in message boxes.)

In the Results Pane you can:

• View the result set for the most recently executed Select query in a spreadsheet-like grid.
  
  
• Edit the values in individual columns in the result set, add new rows, and delete existing rows. For details, see Editing Rows in the Results Pane.

If you change the query definition (for example, add another output column to the query), the Query Designer dims the Results pane to indicate that it no longer reflects the current query. However, you can still navigate in the Results pane grid to edit, add, or delete rows.

In this topic, you can find information about:

• Viewing the Result Set
  
  
• Navigating Through the Results Pane Grid
  
  
• Resizing Grid Rows and Columns
  
  
• Clearing the Results Pane

Viewing the Result Set

When you execute a Select query, the Query Designer displays the result set in the Results pane grid. The Query Designer fetches and displays results incrementally so that you can begin viewing data immediately and perform other tasks while the query is being executed.

The Query Designer uses these conventions when it displays data in the grid:

• Columns containing no value display the word <NULL>.
  
  
• Columns containing binary data display the word <Binary>. You cannot edit the contents of these of columns.
  
  
• Columns containing long varchar-type data display up to 900 characters of data. If the data is longer, the cell displays <Long Text>.
  
  
• Number, currency, time, and date information is formatted according to the options set in the Regional Settings dialog box in the Microsoft^® Windows^® Control Panel.

Navigating Through the Results Pane Grid

To see all of the result set, you can navigate through the Results pane grid. You can use commands on the shortcut menu in the Results pane. In addition, you can use keys or the mouse to navigate through the Results pane grid.

To navigate through the Results pane grid

• Move from cell to cell using the mouse or by pressing TAB, the HOME or END keys, the arrow keys, or CTRL or SHIFT plus any of these keys. For details about how to navigate, see Navigating in the Query Designer.

  –or–

• Use the vertical and horizontal scrollbars in the grid.

  –or–

• Right-click to display the shortcut menu, and then choose First, Last, Next, or Previous, or choose Row to move to a specific row in the grid.

Resizing Grid Rows and Columns

If all of the data for a query does not fit on your screen, you can resize the grid rows and columns.

To resize grid rows

• Move the mouse over the divider between grid rows in the leftmost column until it changes to a double-headed arrow, and then drag the row until it is the size you want. When you resize one row, all other rows are resized at the same time.

To resize a grid column

• Move the mouse over the divider between grid column headers until it changes to a double-headed arrow, and then drag the grid column header until the column is the size you want or double-click to auto-size the column.

Note   The width of the Results pane grid columns has no relationship to the width of the corresponding data columns. Resizing the Results pane grid column does not change the width of the data column in the table.

Clearing the Results Pane

If the Results pane grid contains out-of-date information, you can clear it.

To clear the Results pane grid

• Right-click to display the shortcut menu, and then choose Clear Results.