Editor: Compare gives you the ability to view/query/edit/update files which are currently in use by other applications, and the flexibility of scheduling when such tasks as data transfers and file updates take place.
FEATURES:
• A Job Scheduler that makes it possible to schedule the date, time, and Frequency that tasks will be performed.
• A remote connectivity utility, CompServ, which allows Compare to execute commands/jobs on other machines via a LAN or the Internet.
Compare allows you to write and execute SQL queries on any local dBASE or Paradox database, and, via an Internet or LAN (TCP/IP) connection, execute SQL commands on remote MS Access, SQL Server, or other SQL databases, to insert, update or retrieve data. You may also retrieve data from remote spreadsheets or text files, and save the data as a table in Compare's Access database. Then, from within Compare, you can open, edit, re-save, or delete tables. You can also use the SQL 'INTO' clause to create new tables in Compare's database. Save the SQL statements you write, and re-use them at a later time.
Compare lets you easily manipulate data in local 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 'any field' with data from 'any field' (or entered data); or export fields in File A/B to a file you select.
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!
