Category : Paradox DBMS
Archive   : COMBINE.ZIP
Filename : README
IMPORT1.DB Test Database
IMPORT2.DB Test Database
COMBINE.EXE Executable Program
COMBINE.OVL Paradox Engine Overlay
COMBINE.PAS Source Code
README. This file
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:
Wolfgang Kurtz
CIS: 76264, 1450
PHONE: (907)3449023
Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!
This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.
But one thing that puzzles me is the “mtswslnkmcjklsdlsbdmMICROSOFT” string. There is an article about it here. It is definitely worth a read: http://www.os2museum.com/wp/mtswslnk/