<< Click to Display Table of Contents >>

File Comparison

Top Previous Next

This facility is accessible from both Hora and the SQL Editor.

In Hora, it can be accessed from the SQL Scratchpad by using the context menu, and selecting File | Compare. It also appears on the Toolbar, with the icon FileCompare.

In the SQL Editor, it is reached from File | Compare on the menu bar, or from the context menu.

Selecting the files to be compared

There are several different ways to select the files to select the files to be compared. Here are some examples:

Comparing two files in the Scratchpad

With an item open in Hora's SQL Scratchpad that you would like to compare to another item (remember that items are logical equivalents of actual files):

Click the Compare icon on the Toolbar

An open dialog will start. Use this to select the second file to be compared. Remember that each item corresponds to both a folder and a file in Windows. Be sure to choose the file.

As soon as you do this, the comparison is executed.

Comparing two files in the File Explorer

The File Explorer tab of Hora's SQL Scratchpad lets you select files with a .sql extension anywhere in the file system. Typically, you would use the File Explorer for .sql files that are not in the Scratchpad.

Select the first file to be compared from the lower left window.

Click the Compare icon on the Toolbar

An open dialog will start. Choose any other file anywhere in the Windows file system.

As soon as you do this, the comparison is executed.

Comparing the current file in the SQL Editor with another file

In the SQL Editor, you can start a new file or an edit an existing file. In the first case, you will be prompted to save it when invoking File Comparison.

Start the comparison by using File | Compare.

Save the file if it is new. Otherwise, it will be saved automatically when you start the compare.

An open dialog will start. Choose any other file in the Windows file system.

As soon as you do this, the comparison is executed.

Comparing any two files

You can also use this tool to compare any two text files. However, you must use either Hora or the SQL Editor to start the tool. Consider this to be an added bonus for having bought a KeepTool product!

Use any of the scenarios described above to select the second file to be compared.

As soon as you do this, the comparison is executed.

Use the Open First File icon on the toolbar (first icon) to open a different "first" file.

Press the Compare button to compare these two files.

Understanding the results

file-comparison

The two files are shown next to each other vertically, with matching lines opposite each other in white. Colors are use to indicate non-matching lines. See the key in the status line:

Green represents lines that have been added in the second file.

Red represents lines that have been dropped in the second file.

Blue represents changed lines.

Options

Note the following rather self-explanatory options on the Options menu:

Ignore blanks

Ignore case

Show differences only