Contents of the README file
This archive should consist of six files:
COMBINE.OVLParadox Engine Overlay
This program takes two Paradox database files and combines them into a third table using a keyed update. The Master and Update tables are scanned for field names and types. After all identical fields (field name and type) are identified, the user is asked to specify which of these fields to perform the match/update on. The two tables are then loaded into temporary tables reflecting the user's selections for keyed fields and keys are build in conjunction with the loading process.
Records from the temporary Master are read one at a time, then specified key field values are searched for in the Update table. If a match occurs, a record is added to a Combined table. This record consists of values from the temporary Update table record for all identical fields (name & type) and values from the respective tables where a field exists in only one table. If a match is not made a new record is added to the Combined table reflecting values from the Master table only.
The Combined table's structure is composed of all fields names and types from both Master & Update tables. When a record is matched between the temporary Master & temporary Update tables it is flagged in the temporary Update table. A final pass is made to include in the Combined table all records from the temporary Update table that were not matched in the Master table and therefor flagged. Since the originating tables are keyed and the Combined table is not, it is easy to spot where this last pass is initiated by examining the formerly keyed fields in the Combined table.
To compile the source code you need TurboPower's Object Professional, Borland's Paradox Engine and Turbo Pascal v5.5 or better. This is freeware and all rights regarding the source code are waived by the author. It is a violation of copyright law to attempt to modify or reverse compile Borland's Paradox Engine overlay that accompanies this archive.
If you have any comments please send them to:
CIS: 76264, 1450