<< Click to Display Table of Contents >>

Data Contents

Top Previous Next

It is possible to switch back and forth between Grid View, Record View ,Text View, Chart View, Tree View and Cross Table View using a set of tabs at the top of the grid.

The basic views are:

 

Grid view shows the data in spreadsheet form. You can change the order of the columns by dragging the column header with the mouse. Each column can be resized by dragging the column header divider. You can scroll up and down to see additional table rows.

Record View shows the table as a series of cards, with the columns listed vertically. You can scroll to the left and the right to see additional table rows.

 

In both the grid and record views, you can update data by overtyping, once the current contents have been selected. You can also copy, cut, and paste using the standard Windows key combinations Ctrl + c, Ctrl + x, Ctrl + v.

The Data Contents page comes with an automatic master-detail view. If a master-detail relationship is defined through a foreign key, you can see tabs for detail tables below the master table. Use the tabs at the bottom to switch between No details and any table that has a foreign-key relationship to the current table. In the example below, the HISTORY table's tab has been selected, so that HISTORY records for CUSTOMER 342 are automatically shown.

An additional tab to the right of the detail-table tabs, Other Table..., allows any other table to appear in this window. You have the option of specifying a filter when clicking this tab, to specify a subset of the table. This comes in handy when there is a relationship with the master table that is not defined with a foreign-key constraint. You can specify such a relationship with the syntax parent_id = :id, where :id represents the column name in the new table, and parent_id is the matching column in the parent table.

 

This illustration below also depicts Hora's lookup function. By clicking on the ellipsis in the EMPLOYEE column, the DEPARTMENT table has been brought up in a popup window.

 

frmTables_Contents_GridView

 

From the Grid view, you can also replace the current grid with one representing a master or detail table. Hora does this using the defined referential integrity constraints. Use the context menu items Goto master table and Goto detail table to move to the selected master or detail table, and the related rows of the selected table are displayed. A filter is implicitly set. You can clear it to see the entire table.

The font style of the column header tells more about the table column properties:

Underlined columns are required (non-nullable).

The Record View below shows how dates can be shown on a calendar, and time on a clock.

frmTables_Contents_RecordView

 

Clicking on a non-indexed numeric columns in the grid or record view brings up a calculator.

 

calculator

 

Some enhanced features simplify the entering of data into the table:

When a new record is being inserted, default values are automatically displayed.

The row copy function allows you to insert test data by copying a master record and modifying only primary key and unique key columns.

You can update the contents of any view column that is not marked as non-updatable through graying. This is possible as long as the row in the view points to a unique row in the underlying table.

For BLOBs and CLOBs, you can click on the ellipsis to open the memo editor. The memo editor lets you specify a file from which to load data. It also lets you edit character data, and save the contents to a file.

In Grid View, you can change the order in which rows are displayed by clicking on the column header and dragging it to the left or right. In addition, using the context menu, you can order the rows by any combination of columns contained in an index.

You can enter any valid SQL expression in the filter combo box. The drop-down list contains all recently used filters. Click the Filter Active button to apply the filter. Release the button to clear or change the filter.

 

More information and examples for the other views can be found in the Manipulating the data grid section.

 

The following context operations are available:

29_First

First

Navigates to the first record.

30_Prior

Prior

Navigates to the prior record.

31_Next

Next

Navigates to the next record.

32_Last

Last

Navigates to the last record.

33_Insert

Insert

Inserts an empty record and switches into edit mode.

34_InsertCopy

Insert Copy

Inserts a copy of the current record and switches to edit mode.

35_Delete

Delete

Deletes the current record.

36_Edit

Edit

Switches the current record into edit mode.

37_Post

Post

Posts the changed record to the database server, causing the update to be committed.

38_Cancel

Cancel

Cancels changes made to the current record.

 

Filter by selection

Filters the result set to rows containing the selected cell value in the current column.

 

Goto master table

The menu displays a submenu that shows the names of all master tables of the current table. The foreign-key name in [braces] allows you to choose between multiple master tables.

The data grid will change to display the contents of the selected table. A filter is generated that ensures that you see only data matching the selected row of the current table. You will see only the master record referenced by the foreign key..

 

Goto detail table

The menu displays a submenu that shows the names of all detail tables of the current table. The foreign-key name in [braces] lets you choose between multiple detail tables.

The data grid will change to display the contents of the selected table. A filter is generated that ensures that you see only data matching the selected row of the current table. You will see only detail records referenced by the foreign key.

 

Number as MS windows color

Sometimes MS-Windows colors are stored in the database as their numerical representations. The menu item shows the windows color dialog to let you choose any Windows color and store its numerical representation in the selected field.

158_Report

Report

Invokes the Reporting facility.

157_Excel

Excel export

Automatically exports the table to a Microsoft Excel spreadsheet

 

XML Export

Invokes the XML Export dialog.

 

Export Wizard

Invokes the Export Wizard facility.

 

Import Wizard

Invokes the Import Wizard facility.

112_InsertScript

Create INSERT script

Creates a series of INSERT statements from the current result set. This simplifies data transfer to other applications, version management of basic stock data and data comparison between different databases.

 

Create UPDATE script

Creates a series of UPDATE statements from the current result set. Editing this script would allow selected columns and rows to be updated with new values.

 

Grid View

For more information, see object window