Application:  Compare

Version: 2.6

Purpose: Process database fields based on specified criteria.

Description:
Compare allows you to write, execute, and save SQL queries for any file (.dbf or .db) you open or export.  You may also use the SQL "INTO" clause to create new tables in Compare's Access database.  Then, from within Compare, you can open, edit, and delete the tables.

Compare also allows you to easily manipulate data in dBASE, or Paradox databases, whether two fields in one database or one field in two databases.  Compare gives you the ability to specify various criteria, and processes fields based on those criteria.  
For example: If data in File A is equal/not equal/greater than/less than/before/after data in File B/entered data, delete data in File B/A; replace data in Field A/B with data in Field B/A/whatever; or export fields in File A/B to a file you select.  

If files to be exported from have field names in common, and the fields are selected from both files, Compare can re-create a table in its database with the fields you selected to export from, and additional fields to hold data that is to be exported from the duplicate field(s).  You will then be able to VIEW/Edit the table, save it as a name of your choice, and re-open it for editing or delete it at a later time.  Alternatively, Compare can create a new record, in the file you open to export to, each time data from a duplicate field must be written.  You can view and edit exported data, or any file you open, and add and delete records: all from within Compare.

Imagine having eight thousand rows of data in one file, and three hundred in another, and the task was to get rid of duplicate records!  The flexibility of Compare makes it easy for you to do this.  Since spreadsheet applications, such as Lotus 1-2-3 or Microsoft Excel, make it easy to save a spreadsheet as a .dbf file, Compare can, in effect, work on your spreadsheet data!

Features:
- Open .dbf or .db file, specify your criteria, and hit a button to process files based on your specifications.
- Write, execute, and save SQL queries for any file you open or export.
- Eliminate duplicate records from databases.
- Swap data between fields, or between databases.
- Export fields/records from one database to another if they meet the criteria you specify.
- View file(s) opened for processing.  You may also edit, add, or delete records.
- Sort file(s) by any column by simply double-clicking the column heading.
- Filter file(s) based on any number of criteria.
- Transfer data from as many as three files into Compare's Export TABLE (Data-meld: Compare's version of the Vulcan mind-meld).  This data may be viewed and edited from within Compare.

***********************************************************************
Special REQUIREMENTS: VB5 runtime files must be downloaded from this URL:
http://www.simtel.net/simtel.net/win95/dll.html (vb500a.zip).
***********************************************************************

Installation:  Run setup.exe

***********************************************************************
NOTE: If, during installation, you get a message telling you that a file is already present in a folder (e.g. the system folder) simply click ignore/yes, and continue with the installation.  The message means that the file is probably a shared file that's already on your system.
***********************************************************************

Un-installation:  Select the Add/Remove Programs icon in Control Panel

Program status: Demo

Author:  Gregory Archer

Contact/support: app_arent@yahoo.com