Many tabs and panes in the Database Viewer display database tables in a data grid. In the data grid, you can choose between the Grid, Card, and Layout views.

Grid View

The Grid View displays records in a tabular form and is the only view in which you can edit data. You can customize the grid in the following ways:

• Customize columns to display by right-clicking the column header and selecting one of the following options from the context menu:
  • Remove a column from the display.
  • Launch the Column Chooser window, into which you can drag and drop columns. Any columns that are placed in the Column Chooser window are removed from active display. You can drag a column back from the window to restore it in the grid view.
  • Resize the columns displayed by choosing the Best Fit option.
• Group columns by value by dragging a column into the GroupBy box. You can group by more than one column to establish a hierarchy. Drag the columns back onto the grid to undo the grouping or right-click in the GroupBy box and choose Clear Grouping to undo all groupings.
• Filter columns by value by hovering over a column header to activate a small arrow-shaped filter button that you can click to display a drop-down menu of all unique values in that column. Select a value to filter the column to show only the rows that contain the value you select. Select Custom from the drop-down menu to launch the Custom AutoFilter dialog box, in which you can configure a custom filter condition for the column.

The Grid View also contains the following options:

• Show Find Panel —Displays the Find panel. You can also perform this command using the <Ctrl+F> keyboard shortcut.
• Show Filter Editor —Launches the Filter Editor dialog box.
• Show Auto-Filter Row —Creates an auto-filter row at the top of the grid. You can enter values for each column in the auto-filter row, and the actual data (rows) displayed will be filtered based on these values.

Specifying null as the Value for a Column that Accepts null

You can modify the existing value of a cell to null or specify a null value in a new record by pressing <Ctrl+Delete> in that cell. Entering an empty string to specify null might result in a data type mismatch error for most column data types.

Card View

Card View represents records as cards consisting of fields (each column in the database table maps to one field) that are always arranged one below the other. The number of cards displayed at a time depends on the available space.

You can customize the card view by clicking on the Customize button, which displays a drop-down menu that lists all field names in the view. You can perform the following operations in the menu:

• Remove columns from view by clicking on the tick mark next to a column.
• Filter cards by value by clicking on the Filter option next to each column that displays a drop-down menu of all unique values in the column. Choose one of these values to filter the column data such that the view displays only those cards that contain the selected value. Choose the Custom option from the drop-down menu to launch the Custom AutoFilter dialog box.
  Note

  • Setting any filtering on the view will display the Filter Expression panel at the bottom of the view.
  • Using the keyboard shortcut <Ctrl+F> displays the Find Panel.

Layout View

Layout View displays records as cards, similar to Card View, but you can customize the layout of the cards in the following ways:

• Modify the number of cards displayed at a time using the One Card, One Row, One Column, Multiple Rows, Multiple Columns and Carousel Mode buttons in the header panel.
• Hover over a column or field in a card , which brings up the following controls:
  • Filter —Displays a drop-down menu that lists all unique values in the column. Choose one of these values to display only those cards whose column matches the selected value. You can also choose the Custom option from the drop-down menu, which will launch the Custom AutoFilter dialog box.
  • Sort —Sorts the cards based on the values in that column or field.
    Note Setting any filtering on the Layout View will display the Filter Expression panel at the bottom of the view.
• Click the Customization button , which launches the Layout View Customization dialog box. This dialog box allows you to customize the layout of the cards at run-time, which is the main difference between Card View and Layout View.
  Note

  • Using the keyboard shortcut <Ctrl+F> displays the Find Panel.
  • The panning feature makes it easy to scroll through cards that are only partially visible in the data grid. Click the Panning button in the header panel to activate the panning feature. The mouse cursor will appear as a hand. You can scroll through the view by clicking and dragging.