<< Click to Display Table of Contents >>

Viewing and modifying the result set

Top Previous Next

When you execute a SELECT statement with Execute Query, the server produces a result set. Hora shows you the data in a spreadsheet-like form, like the one on the Introduction to SQL Scratchpad. At first, only the first 25 rows are fetched. Every time you scroll to the bottom of the data grid, another 25 rows are fetched. Please note that all the rows will be fetched if you push the Last Last record button. This might take a while, and it requires considerable memory for very large result sets. That's why it is always a good idea to keep result sets small by adding restrictive where conditions to the SQL.

You can make each query updatable in order to edit data within the grid. The only restrictions are

The grid must contain all columns of  the primary key, or of a unique key, or the ROWID.

For a view, you can update only one table's columns at a time.

The view's column names must be the same as the base table's column names.

To get a live result set, you must tell Hora the name of the table to be updated and the key fields for unique record identification. You can select both of them from combo boxes at the top of the tool window. Multiple field names belonging to a composite key should be separated by semicolons. When you press the Apply and request live result set button, the result set becomes updatable.

The changes you make are posted to the server when you navigate out of the cell or press the check mark icon shown in the grid below. You may then commit or roll back the changes by using the orange Commit and Rollback buttons in the main window.  Of course, you may also commit or rollback by entering an explicit command in the SQL code window. If you press the Rollback button, you will see the changes being backed out.

The right mouse button's context menu allows the following operations, some of which are also available from the toolbar above the results grid:

First

First record

Navigates to the first record.

Prior

Prior record

Navigates to the prior record.

Next

Next record

Navigates to the next record.

Last

Last record

Navigates to the last record.

Insert

Insert blank row

Inserts an empty record and switches into edit mode.

InsertCopy

Insert copy

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

Delete

Delete

Deletes the current record.

Edit

Edit

Switches the current record into edit mode.

Post

Post

Posts the changed record to the database server.

Cancel

Cancel

Cancels changes made to the current record.

SQLReport

Report

Shows the entire result set in an editor window. This will enable you to copy a TAB separated multi-column list to the Windows clipboard.

SQLResultsExcel

Excel Export

Opens the one-click Excel Export Facility

 

Export Wizard

Opens the Export Wizard.

 

Import Wizard

Opens the Import Wizard.

 

Grid View

For more information, see object window

 

Initially, the results window is located at the bottom of the page. If you drag its left border away from the form, it becomes a flying tool window that can be moved around the screen and resized. To dock it back to its host window, narrow the window vertically, and drag it towards the bottom of the page until you see a rectangular shadow; then let go of the mouse.

You can also execute SELECT statements using the Execute Script button. In this case, the output is displayed in the DBMS_OUTPUT window. A "no rows selected" message appears if no rows are selected.