<< Click to Display Table of Contents >>

Introduction

Top Previous Next

The Data Contents Browser facilitates the viewing and editing of several tables or views at the same time. The contents display can easily be tailored to bring in only related rows from other tables. Navigation from one table or view to another is a simple as clicking on a tab. The Data Contents Browser permits updating, inserting, deleting, and copying of rows.

For simplicity, we will refer here to both tables and views here as "tables."

The Data Contents Browser does not have Overview or drill-down tabs. Instead, its tabs represent the tables that have been brought into the Browser. A list of all tables and views in the schema is always available on the left side of the display.

Opening and Populating the Browser

The Data Contents Browser may be opened by clicking on its icon on the Sidebar.

Alternatively, you can open it from the Overview sheet of Hora's Tables page. In this case, the Data Contents Browser will open with the contents of the current table on the Tables page.

You may also bring into the Browser, via the Load Button on the Toolbar, or Object | Workset | Load on the menu, any selection of tables and filters as they appeared in a previous Hora session, if you previously saved your settings.

 

frmDataBrowser_Overview1

 

When opened from the Sidebar, the Data Browser needs to have one or more tables or views brought into it manually. You will see a list of all tables in the schema and a checkbox that lets you add the schema's views to the list.

You can bring a table into view either by double-clicking on it, or selecting it and pressing the Open Table/View button. Using the button will give you the opportunity to specify a filter before loading the table.

It will also give you the option of selecting a table from another schema, using a schema selector.

Once a table is selected, its contents will appear in the Browser, with a new tab representing it.

A third way of bring new tables into the Data Contents Browser is through the Browser's own context menu, where the Goto master table and Goto detail table menu items appear. This will automatically engage a filter that will bring in only rows from the master or detail table that are related to the row at which the cursor is placed in the current table.

Removing Tables or Views from the Display

You can remove a table and its tab by clearing the check box on its tab; or by right-clicking its tab, then Close.

Before closing the Data Contents Browser, you have the ability to save the list of currently open tables and filters in effect by pressing the Save button on the Toolbar, or by using the menu items Object | Workset | Save. You will be prompted to specify a location where the table list will be saved as an XML file.