Change a Grid View

At times you cannot display all grid columns and rows on your monitor. To help navigate a large grid, you can scroll, resize or move grid rows and columns manually, or use key combinations to move around a grid.

Shortcut menu commands allow you to find, replace, sort, hide, or lock grid columns and rows. Right-click a grid heading or grid column to display a shortcut menu.

Grid handling features are similar throughout Optim; any variations for specific editors and dialogs are discussed where applicable.

Adjust a Grid Manually

You can easily resize, move, and scroll grid columns and rows to view all the data in an editor or dialog. You can also delete a numbered grid row.

Resize
To change the width of a grid column, position the pointer at the right boundary of the column to click and drag to the desired position.
Move
You can move a grid column or row. To move a grid:
  • column, select the heading and drag the column.
  • row, select a numbered row and drag it to a new position. The rows renumber automatically.
Scroll
To view complete information in a grid cell, you can resize the grid column to display the entire value or use the horizontal scroll bar below the heading.
Delete
To delete a grid row, click a row number and press Delete.

Scroll Bars

When the grid contains more information than can be viewed on your monitor, you can use the horizontal and vertical scroll bars to adjust the display left and right or to view entries on a list from top to bottom. display of scroll bars on a grid

Click the scroll box to indicate the pointer position on the grid. The vertical scroll box displays the row number and the total number of rows. The horizontal scroll box displays the grid column number and the total number of grid columns.

Key Combinations

In addition to using scroll bars, you can use the following key combinations to move through grid columns and rows.

Tab
Move to the next read/write cell to the right.
Shift+Tab
Move one read/write cell to the left.
Arrow Key
Move one read/write cell in the direction of the arrow key.
Ctrl+Left Arrow
Move to the beginning of a grid row.
Ctrl+Right Arrow
Move to the end of a grid row.
Ctrl+Up Arrow
Move to the top of a grid column.
Ctrl+Down Arrow
Move to the bottom of a grid column.
Ctrl+Home
Move to the first read/write cell in a grid.
Ctrl+End
Move to the last read/write cell in a grid.
Page Up
Scroll up through a grid.
Page Down
Scroll down through a grid.

Grid Heading Shortcut Menu

grid heading shortcut menu showing commands to adjust the data displayed in the grid

Right-click a grid column heading to display a shortcut menu. Select from the following commands to adjust the grid display:

Find
Open the Find dialog where you can specify search criteria to locate a particular value in a grid column. For details on using Find and Replace commands, see Using Find and Replace.
Replace
Open the Replace dialog where you can enter a value or string to be replaced with a different value or string (applies only to grid columns that can be updated).
Exclude
Open the Exclude dialog where you can enter a value or string used to select rows to be excluded.
Include
Open the Include dialog where you can enter a value or string used to select rows to be included.
Sort
Open the Sort menu where you can rearrange the grid rows according to a value or string in a grid column.
Hide
Hide a grid column. To redisplay the grid column, select Unhide All or Reset Grid Attributes from the shortcut menu.
Unhide All
Display hidden grid columns.
Lock
Move a grid column to the left and lock in place. When you lock more than one column, the locked columns are positioned in the order locked. The menu command is Unlock for previously locked columns. To unlock a column, select Unlock.
Note: To unlock all locked grid columns, select Reset Grid Attributes from the shortcut menu.
Reset Grid Attributes
Return the grid components to the original settings, display hidden grid columns, and unlock locked grid columns. Sorted data remains unchanged.
Print
Open the Print dialog to print the rows in the grid.
Save
Open the Save dialog to save all or selected rows.
Grid Patterns
Display the Grid Patterns dialog. Refer to this dialog for a brief description of any cross-hatching patterns used in the dialog from which you right-clicked.
What's This
Display the What's This? pointer. Click a control in an editor or dialog with this pointer to obtain context-sensitive help.

Prefix/Suffix

The Prefix/Suffix dialog is accessible from the grid header shortcut menu in the following dialogs:

Right-click a grid column header and select Prefix/Suffix to display the Prefix/Suffix dialog.

Use the Prefix/Suffix dialog to add a prefix or suffix to any part of a database object name (i.e., table, default, function, package, procedure, rule, sequence, user defined type, or view) in the grid column beneath the header.

The following guidelines apply:

The Prefix/Suffix dialog includes the following:

Column
Displays the name of the column header you right‑clicked.
Operation
Select whether to add a prefix or suffix to, or replace, each item in the column, then enter the value to use.
Apply to
Select the part of the three part object name, as applicable, to apply the prefix or suffix, or to replace.

Grid Column Shortcut Menu

Right-click a grid column to select from shortcut menu commands to edit the entry in a grid cell. The typical field editing function commands are available and correspond to the specific grid column.
display of grid column shortcut menu