<< Click to Display Table of Contents >>

Object windows

Top Previous Next

Hora's main window can contain multiple child windows. Each child window displays information about one and only one special object type (for example, tables or tablespaces) After you press an object window button in the main form or click the View |[ObjectWindow] menu item, the corresponding MDI child window is created (if necessary) and activated.

Most of these MDI child windows display master/detail data. Multiple tabs in the top of the window determine which detail data is displayed.

The first, or Overview tab shows only information about the master object, for example Tables and Views. You will see one data grid filling the complete client area of the window.

Each other tab shows limited information from the master view on the left and specific additional detail information on the right. This enables you to scroll through the list of master objects on the left, and see the corresponding detail data on the right. For example, you can browse a list of table names, and see the selected table's column definitions on the right.

Click the chosen tab a second time to refresh the display.

You can also toggle through the tab sheets with the TAB key while holding down the CTRL key. Hold the CTRL and SHIFT keys down together to toggle between the tabs in reverse order.

Many of the object windows have a set of 26 alphabetic navigation buttons at the bottom or on the side, which serve to locate the first object name in the overview that starts with the chosen character.  The alphabetic navigation buttons to the left of the grid can be toggled on or off by selecting View | Navigation Bar from the menu.

 

object windows

 

From the Overview page, you can just type a letter on the keyboard. The cursor navigates to the first object in the list that starts with this letter. Every succeeding letter that you type will bring you closer to the object whose name you are entering.

You can also use the following keys to navigate within the list:

Home

Page up

Cursor up

Cursor down

Page down

End

 

Most windows allow you to select several objects simultaneously. For example, if you want to drop several tables at the same time, you can select their names with the mouse while holding down the Ctrl key. Then, when you click the Drop button, all the selected tables will be dropped.

Some object windows provide the Grid View item on their context menu. This will then show the following submenu, or portions of it:

 

01_Print

Print

Prints the contents of the grid.

 

Show group by box

Displays a grouping panel at the top of the grid (for more information, see manipulating the data grid)

 

Show group footer

Displays a footer panel for each group  (for more information, see manipulating the data grid)

 

Show footer

Displays a footer for the grid as a whole  (for more information, see manipulating the data grid)

 

Expand Groups

Expand all groups

 

Collapse Groups

Closes all groups

 

Expand subviews

Expand all subordinate groups

 

Collapse subviews

Closes all subordinate groups

 

Data Export Wizard

Opens the Export Wizard.

 

Result to logfile

Fetches the entire result set from the server and dumps the data to the log file

 

Refresh

Refreshes the grid

 

Best fit columns

Adjust the column widths to fit the size of the data

 

 

Some data grid cells that contain percentages display miniature bar graphs below the characters. The percentages are underlined with small red- and green-colored gauges.

You can use the Close button, the Enter key or the Escape key to close the dialog.