https://wiki.amstrad-cpc.net/index.php?action=history&feed=atom&title=On_FileOn File - Revision history2026-09-03T15:44:09ZRevision history for this page on the wikiMediaWiki 1.46.0https://wiki.amstrad-cpc.net/index.php?title=On_File&diff=121867&oldid=prevKSL at 16:34, 15 August 20252025-08-15T16:34:10Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw-interface="">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 16:34, 15 August 2025</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l9">Line 9:</td>
<td colspan="2" class="diff-lineno">Line 9:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>'''On File (2025)''' Database Management System for '''CP/M plus''' was released in June 2025. In addition to the 2024 version, it includes the options to Group and to Invert the records, to Index the database, to perform Index based search and to perform field based calculations. It also supports [[GSX]], '''field-based graphics''', unlimited number of Relational Keys and On Board help. It also includes '''On File Register''', a RAM-disk based register book. The latter provides capacity for a few thousands of single-field records. On File 2025 requires RAM expansion to run and includes a resume option in order to access the RAM-disk contents upon restart. The original disk contains CP/M plus boot sectors (Dobbertin v1.1x), a database of old computers and a register book for the period 1970-1989. On File database (2024/2025) is disk-based, thus all the records are stored in the disk drive as stand-alone files. On the other hand, On File Register uses a single file to store the records in the RAM-disk. For large register books which contain more than 64 records, a 16 KB "cache" memory is implemented in order to be able to move back and forth while reading the records. Notice, that in the 2025 version, in order to maximize the free directory entries and to overcome the Compiler and Editor Overflow, a big part of the On File source code (ONFILE.COM) has been '''encapsulated in the source code''' of the Register Book (REGISTER.COM) and is accessed upon user request via boolean expressions that are temporarily stored in the RAM-disk. </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>'''On File (2025)''' Database Management System for '''CP/M plus''' was released in June 2025. In addition to the 2024 version, it includes the options to Group and to Invert the records, to Index the database, to perform Index based search and to perform field based calculations. It also supports [[GSX]], '''field-based graphics''', unlimited number of Relational Keys and On Board help. It also includes '''On File Register''', a RAM-disk based register book. The latter provides capacity for a few thousands of single-field records. On File 2025 requires RAM expansion to run and includes a resume option in order to access the RAM-disk contents upon restart. The original disk contains CP/M plus boot sectors (Dobbertin v1.1x), a database of old computers and a register book for the period 1970-1989. On File database (2024/2025) is disk-based, thus all the records are stored in the disk drive as stand-alone files. On the other hand, On File Register uses a single file to store the records in the RAM-disk. For large register books which contain more than 64 records, a 16 KB "cache" memory is implemented in order to be able to move back and forth while reading the records. Notice, that in the 2025 version, in order to maximize the free directory entries and to overcome the Compiler and Editor Overflow, a big part of the On File source code (ONFILE.COM) has been '''encapsulated in the source code''' of the Register Book (REGISTER.COM) and is accessed upon user request via boolean expressions that are temporarily stored in the RAM-disk. </div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>What gap of the 80's does On File (2025) come to fill? Let’s give <del style="font-weight: bold; text-decoration: none;">an </del>example. Using On File Register, a register book can be set up <del style="font-weight: bold; text-decoration: none;">with</del>, <del style="font-weight: bold; text-decoration: none;">for example</del>, <del style="font-weight: bold; text-decoration: none;">5000 citizens of a town. The register book (~210 KB) is saved in disk (disk 0) </del>and <del style="font-weight: bold; text-decoration: none;">is loaded once in the RAM of the CPC6128</del>. Then<del style="font-weight: bold; text-decoration: none;">, </del>using On File Database, <del style="font-weight: bold; text-decoration: none;">a full-screen record can be created for each citizen. The </del>records of the <del style="font-weight: bold; text-decoration: none;">database are saved in 26 different disks (disks A-Z or HD20), depending on the surname of each resident</del>. <del style="font-weight: bold; text-decoration: none;">Notice, that </del>the <del style="font-weight: bold; text-decoration: none;">register book remains in RAM until the end of the work regardless </del>of <del style="font-weight: bold; text-decoration: none;">which disk (A-Z/HD20) is used</del>. <del style="font-weight: bold; text-decoration: none;">Upon exit, the contents of the RAM (register book, if modified) are saved in disk 0. </del>This can be achieved with an Amstrad CPC6128 with 512 KB RAM expansion, a 800 KB external floppy drive, the specific version of CP/M plus (v1.1x), RamDOS D20 disks or HD20. </div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>What gap of the 80's does On File (2025) come to fill? Let’s give <ins style="font-weight: bold; text-decoration: none;">a “professional” </ins>example. Using On File Register, a register book <ins style="font-weight: bold; text-decoration: none;">of earthquakes that are realized in a specific country </ins>can be set up, <ins style="font-weight: bold; text-decoration: none;">including Serial Number, Date, Time, Location, Duration</ins>, <ins style="font-weight: bold; text-decoration: none;">Depth </ins>and <ins style="font-weight: bold; text-decoration: none;">Magnitude</ins>. Then using On File Database, <ins style="font-weight: bold; text-decoration: none;">detailed </ins>records of the <ins style="font-weight: bold; text-decoration: none;">earthquakes that where stronger than e.g</ins>. <ins style="font-weight: bold; text-decoration: none;">5 Richter can be set up including </ins>the <ins style="font-weight: bold; text-decoration: none;">map </ins>of <ins style="font-weight: bold; text-decoration: none;">their location</ins>. This can be achieved with an Amstrad CPC6128 with 512 KB RAM expansion, a 800 KB external floppy drive, the specific version of CP/M plus (v1.1x), RamDOS D20 disks or HD20.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Using the following two links you can download On FIle (2024) and On File (2025) respectively.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Using the following two links you can download On FIle (2024) and On File (2025) respectively.</div></td></tr>
</table>KSLhttps://wiki.amstrad-cpc.net/index.php?title=On_File&diff=121866&oldid=prevKSL at 11:25, 10 June 20252025-06-10T11:25:48Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw-interface="">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 11:25, 10 June 2025</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l9">Line 9:</td>
<td colspan="2" class="diff-lineno">Line 9:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>'''On File (2025)''' Database Management System for '''CP/M plus''' was released in June 2025. In addition to the 2024 version, it includes the options to Group and to Invert the records, to Index the database, to perform Index based search and to perform field based calculations. It also supports [[GSX]], '''field-based graphics''', unlimited number of Relational Keys and On Board help. It also includes '''On File Register''', a RAM-disk based register book. The latter provides capacity for a few thousands of single-field records. On File 2025 requires RAM expansion to run and includes a resume option in order to access the RAM-disk contents upon restart. The original disk contains CP/M plus boot sectors (Dobbertin v1.1x), a database of old computers and a register book for the period 1970-1989. On File database (2024/2025) is disk-based, thus all the records are stored in the disk drive as stand-alone files. On the other hand, On File Register uses a single file to store the records in the RAM-disk. For large register books which contain more than 64 records, a 16 KB "cache" memory is implemented in order to be able to move back and forth while reading the records. Notice, that in the 2025 version, in order to maximize the free directory entries and to overcome the Compiler and Editor Overflow, a big part of the On File source code (ONFILE.COM) has been '''encapsulated in the source code''' of the Register Book (REGISTER.COM) and is accessed upon user request via boolean expressions that are temporarily stored in the RAM-disk. </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>'''On File (2025)''' Database Management System for '''CP/M plus''' was released in June 2025. In addition to the 2024 version, it includes the options to Group and to Invert the records, to Index the database, to perform Index based search and to perform field based calculations. It also supports [[GSX]], '''field-based graphics''', unlimited number of Relational Keys and On Board help. It also includes '''On File Register''', a RAM-disk based register book. The latter provides capacity for a few thousands of single-field records. On File 2025 requires RAM expansion to run and includes a resume option in order to access the RAM-disk contents upon restart. The original disk contains CP/M plus boot sectors (Dobbertin v1.1x), a database of old computers and a register book for the period 1970-1989. On File database (2024/2025) is disk-based, thus all the records are stored in the disk drive as stand-alone files. On the other hand, On File Register uses a single file to store the records in the RAM-disk. For large register books which contain more than 64 records, a 16 KB "cache" memory is implemented in order to be able to move back and forth while reading the records. Notice, that in the 2025 version, in order to maximize the free directory entries and to overcome the Compiler and Editor Overflow, a big part of the On File source code (ONFILE.COM) has been '''encapsulated in the source code''' of the Register Book (REGISTER.COM) and is accessed upon user request via boolean expressions that are temporarily stored in the RAM-disk. </div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>What gap of the 80's does On File (2025) come to fill? Let’s give an example. Using On File Register, a register book can be set up with, for example, 5000 citizens of a town. The register book is saved in disk (disk 0) and is loaded once in the RAM of the CPC6128. Then, using On File Database, a full-screen record can be created for each citizen. The records of the database are saved in 26 different disks (disks A-Z), depending on the surname of each resident. Notice, that the register book remains in RAM until the end of the work regardless of which disk (A-Z) is used. Upon exit, the contents of the RAM (register book, if modified) are saved in disk 0. This can be achieved with an Amstrad CPC6128 with 512 KB RAM expansion, a 800 KB external floppy drive, the specific version of CP/M plus (v1.1x) <del style="font-weight: bold; text-decoration: none;">and </del>RamDOS D20 disks. </div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>What gap of the 80's does On File (2025) come to fill? Let’s give an example. Using On File Register, a register book can be set up with, for example, 5000 citizens of a town. The register book <ins style="font-weight: bold; text-decoration: none;">(~210 KB) </ins>is saved in disk (disk 0) and is loaded once in the RAM of the CPC6128. Then, using On File Database, a full-screen record can be created for each citizen. The records of the database are saved in 26 different disks (disks A-Z <ins style="font-weight: bold; text-decoration: none;">or HD20</ins>), depending on the surname of each resident. Notice, that the register book remains in RAM until the end of the work regardless of which disk (A-Z<ins style="font-weight: bold; text-decoration: none;">/HD20</ins>) is used. Upon exit, the contents of the RAM (register book, if modified) are saved in disk 0. This can be achieved with an Amstrad CPC6128 with 512 KB RAM expansion, a 800 KB external floppy drive, the specific version of CP/M plus (v1.1x)<ins style="font-weight: bold; text-decoration: none;">, </ins>RamDOS D20 disks <ins style="font-weight: bold; text-decoration: none;">or HD20</ins>. </div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div> </div></td><td colspan="2" class="diff-side-added"></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Using the following two links you can download On FIle (2024) and On File (2025) respectively.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Using the following two links you can download On FIle (2024) and On File (2025) respectively.</div></td></tr>
</table>KSLhttps://wiki.amstrad-cpc.net/index.php?title=On_File&diff=121865&oldid=prevKSL at 13:38, 6 June 20252025-06-06T13:38:47Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw-interface="">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 13:38, 6 June 2025</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l5">Line 5:</td>
<td colspan="2" class="diff-lineno">Line 5:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Image:OnFile_2025_CPC6128_Record.jpg|right|thumb|250px|On File (2025) CPC6128 record which also includes field-based graphics]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Image:OnFile_2025_CPC6128_Record.jpg|right|thumb|250px|On File (2025) CPC6128 record which also includes field-based graphics]]</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>'''On File (2024)''' Database Management System was released in June 2024 by [[KSL]] in order to celebrate the anniversaries of CPC (40 years!) and CP/M-80 (50 years!). On File is a business application similar to the MSDOS-era PC applications and one of the most recent projects developed for '''CP/M 2.2'''. As per [[Cosmos]], On File has been developed on the basis of <del style="font-weight: bold; text-decoration: none;">all </del>the hardware peripherals as well as the software that were (contemporary) available for the CP/M and the CPC6128. However, it can run on a standard single drive CPC6128. On File database is efficient, quick and reliable and can be used on an everyday basis using the CPC emulators. <del style="font-weight: bold; text-decoration: none;">On File database </del>uses the entire CPC screen as the platform for the records; thus there is plenty of space to edit user-defined fields. In addition, a wide variety of characters and symbols can be included in the fileds, hence the records can contain data beyond the typical and traditional text type<del style="font-weight: bold; text-decoration: none;">. Setting up a new database using On File database is very easy and can be performed in three steps: 1) start the new file system by resetting the database and the master record, 2) frame/draw and edit the structure of the master record, 3) append new records in the database on the basis of the master record</del>. On File database is fully dynamic, thus the user can modify the master record as well as any record anytime. Furthermore, the database can be either flat or relational. On File database has maximum capacity of 200 records (400 KB). The original disk <del style="font-weight: bold; text-decoration: none;">(2024) </del>contains the boot sectors for CP/M 2.2 (Dobbertin v1.2 for 128 KB <del style="font-weight: bold; text-decoration: none;">machines</del>), a few demo master records (*.002 files), a few database examples, the application (COM file), as well as the color screen saver (CHN file).</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>'''On File (2024)''' Database Management System was released in June 2024 by [[KSL]] in order to celebrate the anniversaries of CPC (40 years!) and CP/M-80 (50 years!). On File is a business application similar to the MSDOS-era PC applications and one of the most recent projects developed for '''CP/M 2.2'''. As per [[Cosmos]], On File has been developed on the basis of the hardware peripherals as well as the software that were (contemporary) available for the CP/M and the CPC6128. However, it can run on a standard single drive CPC6128. On File database is efficient, quick and reliable and can be used on an everyday basis using the CPC emulators. <ins style="font-weight: bold; text-decoration: none;">It </ins>uses the entire CPC screen as the platform for the records; thus there is plenty of space to edit user-defined fields. In addition, a wide variety of characters and symbols can be included in the fileds, hence the records can contain data beyond the typical and traditional text type. On File database is fully dynamic, thus the user can modify the master record as well as any record anytime. Furthermore, the database can be either flat or relational. On File <ins style="font-weight: bold; text-decoration: none;">(2024) </ins>database has maximum capacity of 200 records (400 KB). The original disk contains the boot sectors for CP/M 2.2 (Dobbertin v1.2 for 128 KB <ins style="font-weight: bold; text-decoration: none;">RAM</ins>), a few demo master records (*.002 files), a few database examples, the application (COM file), as well as the color screen saver (CHN file).</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>'''On File (2025)''' Database Management System for '''CP/M plus''' was released in June 2025. In addition to the 2024 version, it includes the options to Group and to Invert the records, to Index the database, to perform Index based search and to perform field based <del style="font-weight: bold; text-decoration: none;">sum </del>calculations. It also supports [[GSX]], '''field-based graphics''', unlimited number of <del style="font-weight: bold; text-decoration: none;">relational keys </del>and On Board help. It also includes '''On File Register''', a RAM-disk based register book. The latter provides capacity for a few thousands of single-field records. On File 2025 requires RAM expansion to run and includes a resume option in order to access the RAM-disk contents upon restart. The original disk contains CP/M plus boot sectors (Dobbertin v1.1x), a database of old computers and a register book for the period 1970-<del style="font-weight: bold; text-decoration: none;">1980</del>. </div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>'''On File (2025)''' Database Management System for '''CP/M plus''' was released in June 2025. In addition to the 2024 version, it includes the options to Group and to Invert the records, to Index the database, to perform Index based search and to perform field based calculations. It also supports [[GSX]], '''field-based graphics''', unlimited number of <ins style="font-weight: bold; text-decoration: none;">Relational Keys </ins>and On Board help. It also includes '''On File Register''', a RAM-disk based register book. The latter provides capacity for a few thousands of single-field records. On File 2025 requires RAM expansion to run and includes a resume option in order to access the RAM-disk contents upon restart. The original disk contains CP/M plus boot sectors (Dobbertin v1.1x), a database of old computers and a register book for the period 1970-<ins style="font-weight: bold; text-decoration: none;">1989. On File database (2024/2025) is disk-based, thus all the records are stored in the disk drive as stand-alone files. On the other hand, On File Register uses a single file to store the records in the RAM-disk. For large register books which contain more than 64 records, a 16 KB "cache" memory is implemented in order to be able to move back and forth while reading the records. Notice, that in the 2025 version, in order to maximize the free directory entries and to overcome the Compiler and Editor Overflow, a big part of the On File source code (ONFILE.COM) has been '''encapsulated in the source code''' of the Register Book (REGISTER.COM) and is accessed upon user request via boolean expressions that are temporarily stored in the RAM-disk</ins>. </div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">On File database (2024/2025) is disk-based, thus all the records are stored in the disk drive as stand-alone files. On the other hand, On File Register uses a single file to store the records in the RAM-disk. For large register books which contain more than 64 records, a 16 KB "cache" memory is implemented in order to be able to move back and forth while reading the records. Notice, that in the 2025 version, in order to maximize the free directory entries and to overcome the Compiler and Editor Overflow, a big part </del>of the <del style="font-weight: bold; text-decoration: none;">On File source code (ONFILE.COM) has been '''encapsulated in the source code</del>'<del style="font-weight: bold; text-decoration: none;">'' of the Register Book (REGISTER.COM) and is accessed upon user request via boolean expressions that are temporarily stored in the RAM-disk. </del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">What gap </ins>of the <ins style="font-weight: bold; text-decoration: none;">80</ins>'<ins style="font-weight: bold; text-decoration: none;">s </ins>does On File (2025) come to fill? Let’s give an example. Using On File Register, a register book can be set up with, for example, 5000 citizens of a town. The register book is saved <ins style="font-weight: bold; text-decoration: none;">in </ins>disk (disk 0) and is loaded <ins style="font-weight: bold; text-decoration: none;">once </ins>in <ins style="font-weight: bold; text-decoration: none;">the </ins>RAM of the CPC6128. Then, using On File Database, a full-screen record can be created for each citizen. The records of the database are saved <ins style="font-weight: bold; text-decoration: none;">in </ins>26 different disks (disks A-Z), depending on the surname of each resident. <ins style="font-weight: bold; text-decoration: none;">Notice, that the </ins>register book remains <ins style="font-weight: bold; text-decoration: none;">in RAM </ins>until the end of the work regardless of which disk (A-Z) is <ins style="font-weight: bold; text-decoration: none;">used</ins>. Upon exit, the contents of the RAM (register book, if modified) are saved <ins style="font-weight: bold; text-decoration: none;">in </ins>disk 0. This can be achieved with an Amstrad CPC6128 with 512 KB RAM expansion<ins style="font-weight: bold; text-decoration: none;">, a </ins>800 KB external floppy drive<ins style="font-weight: bold; text-decoration: none;">, the specific version of CP/M plus (v1.1x) and RamDOS D20 disks</ins>. </div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div> </div></td><td colspan="2" class="diff-side-added"></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">What gap </del>does On File (2025) come to fill? Let’s give an example.</div></td><td colspan="2" class="diff-side-added"></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Using On File Register, a register book can be set up with, for example, 5000 citizens of a <del style="font-weight: bold; text-decoration: none;">small </del>town. The register book is saved <del style="font-weight: bold; text-decoration: none;">on </del>disk (disk 0) and is loaded in RAM of the CPC6128. Then, using On File Database, a full-screen record can be created for each citizen. The records of the database are saved <del style="font-weight: bold; text-decoration: none;">on </del>26 different disks (disks A-Z), depending on the surname of each resident. <del style="font-weight: bold; text-decoration: none;">The </del>register book <del style="font-weight: bold; text-decoration: none;">is loaded (from disk 0) into memory once and </del>remains <del style="font-weight: bold; text-decoration: none;">there </del>until the end of the work regardless of which disk (A-Z) is <del style="font-weight: bold; text-decoration: none;">in drive B</del>. Upon exit, the contents of the RAM (register book, if modified) are saved <del style="font-weight: bold; text-decoration: none;">on </del>disk 0. This can be achieved with an Amstrad CPC6128 with 512 KB RAM expansion <del style="font-weight: bold; text-decoration: none;">and </del>800 KB external floppy drive. </div></td><td colspan="2" class="diff-side-added"></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
</table>KSLhttps://wiki.amstrad-cpc.net/index.php?title=On_File&diff=121864&oldid=prevKSL at 13:58, 5 June 20252025-06-05T13:58:18Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw-interface="">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 13:58, 5 June 2025</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l12">Line 12:</td>
<td colspan="2" class="diff-lineno">Line 12:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>What gap does On File (2025) come to fill? Let’s give an example.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>What gap does On File (2025) come to fill? Let’s give an example.</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Using On File Register, a register book can be set up with, for example, 5000 citizens of a small town. The <del style="font-weight: bold; text-decoration: none;">Register Book </del>is saved on disk (disk 0) and is loaded in RAM of the CPC6128. Then, using On File Database, a full-screen record can be created for each citizen. The records of the database are saved on 26 different disks (disks A-Z), depending on the surname of each resident. The register book is loaded (from disk 0) into memory once and remains there until the end of the work regardless of which disk (A-Z) is in drive B. Upon exit, the contents of the RAM (<del style="font-weight: bold; text-decoration: none;">Register </del>book, if modified) are saved on disk 0. This can be achieved with an Amstrad CPC6128 with 512 KB RAM expansion and 800 KB external floppy drive. </div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Using On File Register, a register book can be set up with, for example, 5000 citizens of a small town. The <ins style="font-weight: bold; text-decoration: none;">register book </ins>is saved on disk (disk 0) and is loaded in RAM of the CPC6128. Then, using On File Database, a full-screen record can be created for each citizen. The records of the database are saved on 26 different disks (disks A-Z), depending on the surname of each resident. The register book is loaded (from disk 0) into memory once and remains there until the end of the work regardless of which disk (A-Z) is in drive B. Upon exit, the contents of the RAM (<ins style="font-weight: bold; text-decoration: none;">register </ins>book, if modified) are saved on disk 0. This can be achieved with an Amstrad CPC6128 with 512 KB RAM expansion and 800 KB external floppy drive. </div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
</table>KSLhttps://wiki.amstrad-cpc.net/index.php?title=On_File&diff=121863&oldid=prevKSL at 13:56, 5 June 20252025-06-05T13:56:05Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw-interface="">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 13:56, 5 June 2025</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l7">Line 7:</td>
<td colspan="2" class="diff-lineno">Line 7:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>'''On File (2024)''' Database Management System was released in June 2024 by [[KSL]] in order to celebrate the anniversaries of CPC (40 years!) and CP/M-80 (50 years!). On File is a business application similar to the MSDOS-era PC applications and one of the most recent projects developed for '''CP/M 2.2'''. As per [[Cosmos]], On File has been developed on the basis of all the hardware peripherals as well as the software that were (contemporary) available for the CP/M and the CPC6128. However, it can run on a standard single drive CPC6128. On File database is efficient, quick and reliable and can be used on an everyday basis using the CPC emulators. On File database uses the entire CPC screen as the platform for the records; thus there is plenty of space to edit user-defined fields. In addition, a wide variety of characters and symbols can be included in the fileds, hence the records can contain data beyond the typical and traditional text type. Setting up a new database using On File database is very easy and can be performed in three steps: 1) start the new file system by resetting the database and the master record, 2) frame/draw and edit the structure of the master record, 3) append new records in the database on the basis of the master record. On File database is fully dynamic, thus the user can modify the master record as well as any record anytime. Furthermore, the database can be either flat or relational. On File database has maximum capacity of 200 records (400 KB). The original disk (2024) contains the boot sectors for CP/M 2.2 (Dobbertin v1.2 for 128 KB machines), a few demo master records (*.002 files), a few database examples, the application (COM file), as well as the color screen saver (CHN file).</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>'''On File (2024)''' Database Management System was released in June 2024 by [[KSL]] in order to celebrate the anniversaries of CPC (40 years!) and CP/M-80 (50 years!). On File is a business application similar to the MSDOS-era PC applications and one of the most recent projects developed for '''CP/M 2.2'''. As per [[Cosmos]], On File has been developed on the basis of all the hardware peripherals as well as the software that were (contemporary) available for the CP/M and the CPC6128. However, it can run on a standard single drive CPC6128. On File database is efficient, quick and reliable and can be used on an everyday basis using the CPC emulators. On File database uses the entire CPC screen as the platform for the records; thus there is plenty of space to edit user-defined fields. In addition, a wide variety of characters and symbols can be included in the fileds, hence the records can contain data beyond the typical and traditional text type. Setting up a new database using On File database is very easy and can be performed in three steps: 1) start the new file system by resetting the database and the master record, 2) frame/draw and edit the structure of the master record, 3) append new records in the database on the basis of the master record. On File database is fully dynamic, thus the user can modify the master record as well as any record anytime. Furthermore, the database can be either flat or relational. On File database has maximum capacity of 200 records (400 KB). The original disk (2024) contains the boot sectors for CP/M 2.2 (Dobbertin v1.2 for 128 KB machines), a few demo master records (*.002 files), a few database examples, the application (COM file), as well as the color screen saver (CHN file).</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>'''On File (2025)''' Database Management System for '''CP/M plus''' was released in June 2025. In addition to the 2024 version, it includes the options to Group and to Invert the records, to Index the database, to perform Index based search and to perform field based sum calculations. It also supports [[GSX]], '''field-based graphics''', unlimited number of relational keys and On Board help. It also includes '''On File Register''', a RAM-disk based register book. The latter provides capacity for a few thousands of single-field records. On File 2025 requires RAM expansion to run and includes a resume option in order to access the RAM-disk contents upon restart. The original disk contains CP/M plus (Dobbertin v1.1x) <del style="font-weight: bold; text-decoration: none;">boot sectors</del>, a database of old computers and a register book for the period 1970-1980. </div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>'''On File (2025)''' Database Management System for '''CP/M plus''' was released in June 2025. In addition to the 2024 version, it includes the options to Group and to Invert the records, to Index the database, to perform Index based search and to perform field based sum calculations. It also supports [[GSX]], '''field-based graphics''', unlimited number of relational keys and On Board help. It also includes '''On File Register''', a RAM-disk based register book. The latter provides capacity for a few thousands of single-field records. On File 2025 requires RAM expansion to run and includes a resume option in order to access the RAM-disk contents upon restart. The original disk contains CP/M plus <ins style="font-weight: bold; text-decoration: none;">boot sectors </ins>(Dobbertin v1.1x), a database of old computers and a register book for the period 1970-1980. </div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>On File database (2024/2025) is disk-based, thus all the records are stored in the disk drive as stand-alone files. On the other hand, On File Register uses a single file to store the records in the RAM-disk. For large register books which contain more than 64 records, a 16 KB "cache" memory is implemented in order to be able to move back and forth while reading the records. Notice, that in the 2025 version, in order to maximize the free directory entries and to overcome the Compiler and Editor Overflow, a big part of the On File source code (ONFILE.COM) has been '''encapsulated in the source code''' of the Register Book (REGISTER.COM) and is accessed upon user request via boolean expressions that are temporarily stored in the RAM-disk. </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>On File database (2024/2025) is disk-based, thus all the records are stored in the disk drive as stand-alone files. On the other hand, On File Register uses a single file to store the records in the RAM-disk. For large register books which contain more than 64 records, a 16 KB "cache" memory is implemented in order to be able to move back and forth while reading the records. Notice, that in the 2025 version, in order to maximize the free directory entries and to overcome the Compiler and Editor Overflow, a big part of the On File source code (ONFILE.COM) has been '''encapsulated in the source code''' of the Register Book (REGISTER.COM) and is accessed upon user request via boolean expressions that are temporarily stored in the RAM-disk. </div></td></tr>
</table>KSLhttps://wiki.amstrad-cpc.net/index.php?title=On_File&diff=121862&oldid=prevKSL at 13:55, 5 June 20252025-06-05T13:55:13Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw-interface="">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 13:55, 5 June 2025</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l7">Line 7:</td>
<td colspan="2" class="diff-lineno">Line 7:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>'''On File (2024)''' Database Management System was released in June 2024 by [[KSL]] in order to celebrate the anniversaries of CPC (40 years!) and CP/M-80 (50 years!). On File is a business application similar to the MSDOS-era PC applications and one of the most recent projects developed for '''CP/M 2.2'''. As per [[Cosmos]], On File has been developed on the basis of all the hardware peripherals as well as the software that were (contemporary) available for the CP/M and the CPC6128. However, it can run on a standard single drive CPC6128. On File database is efficient, quick and reliable and can be used on an everyday basis using the CPC emulators. On File database uses the entire CPC screen as the platform for the records; thus there is plenty of space to edit user-defined fields. In addition, a wide variety of characters and symbols can be included in the fileds, hence the records can contain data beyond the typical and traditional text type. Setting up a new database using On File database is very easy and can be performed in three steps: 1) start the new file system by resetting the database and the master record, 2) frame/draw and edit the structure of the master record, 3) append new records in the database on the basis of the master record. On File database is fully dynamic, thus the user can modify the master record as well as any record anytime. Furthermore, the database can be either flat or relational. On File database has maximum capacity of 200 records (400 KB). The original disk (2024) contains the boot sectors for CP/M 2.2 (Dobbertin v1.2 for 128 KB machines), a few demo master records (*.002 files), a few database examples, the application (COM file), as well as the color screen saver (CHN file).</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>'''On File (2024)''' Database Management System was released in June 2024 by [[KSL]] in order to celebrate the anniversaries of CPC (40 years!) and CP/M-80 (50 years!). On File is a business application similar to the MSDOS-era PC applications and one of the most recent projects developed for '''CP/M 2.2'''. As per [[Cosmos]], On File has been developed on the basis of all the hardware peripherals as well as the software that were (contemporary) available for the CP/M and the CPC6128. However, it can run on a standard single drive CPC6128. On File database is efficient, quick and reliable and can be used on an everyday basis using the CPC emulators. On File database uses the entire CPC screen as the platform for the records; thus there is plenty of space to edit user-defined fields. In addition, a wide variety of characters and symbols can be included in the fileds, hence the records can contain data beyond the typical and traditional text type. Setting up a new database using On File database is very easy and can be performed in three steps: 1) start the new file system by resetting the database and the master record, 2) frame/draw and edit the structure of the master record, 3) append new records in the database on the basis of the master record. On File database is fully dynamic, thus the user can modify the master record as well as any record anytime. Furthermore, the database can be either flat or relational. On File database has maximum capacity of 200 records (400 KB). The original disk (2024) contains the boot sectors for CP/M 2.2 (Dobbertin v1.2 for 128 KB machines), a few demo master records (*.002 files), a few database examples, the application (COM file), as well as the color screen saver (CHN file).</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>'''On File (2025)''' Database Management System for '''CP/M plus''' was released in June 2025. In addition to the 2024 version, it includes the options to Group and to Invert the records, to Index the database, to perform Index based search and to perform field based sum calculations. It also supports [[GSX]], '''field-based graphics''', unlimited number of relational keys and On Board help. It also includes '''On File Register''', a RAM-disk based register book. The latter provides capacity for a few thousands of single-field records<del style="font-weight: bold; text-decoration: none;">. Hence, the user can set up e.g. a Register of Earthquakes (date, time, location, magnitude, depth, duration) using On File Register, while keeping detailed records of specific earthquakes (e.g. > 6 R) using On File Database</del>. On File 2025 requires RAM expansion to run and includes a resume option in order to access the RAM-disk contents upon restart. The original disk contains CP/M plus (Dobbertin v1.1x) boot sectors, a database of old computers and a register book for the period 1970-1980. On File database (2024/2025) is disk-based, thus all the records are stored in the disk drive as stand-alone files. On the other hand, On File Register uses a single file to store the records in the RAM-disk. For large register books which contain more than 64 records, a 16 KB "cache" memory is implemented in order to be able to move back and forth while reading the records. Notice, that in the 2025 version, in order to maximize the free directory entries and to overcome the Compiler and Editor Overflow, a big part of the On File source code (ONFILE.COM) has been '''encapsulated in the source code''' of the Register Book (REGISTER.COM) and is accessed upon user request via boolean expressions that are temporarily stored in the RAM-disk. </div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>'''On File (2025)''' Database Management System for '''CP/M plus''' was released in June 2025. In addition to the 2024 version, it includes the options to Group and to Invert the records, to Index the database, to perform Index based search and to perform field based sum calculations. It also supports [[GSX]], '''field-based graphics''', unlimited number of relational keys and On Board help. It also includes '''On File Register''', a RAM-disk based register book. The latter provides capacity for a few thousands of single-field records. On File 2025 requires RAM expansion to run and includes a resume option in order to access the RAM-disk contents upon restart. The original disk contains CP/M plus (Dobbertin v1.1x) boot sectors, a database of old computers and a register book for the period 1970-1980. </div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>On File database (2024/2025) is disk-based, thus all the records are stored in the disk drive as stand-alone files. On the other hand, On File Register uses a single file to store the records in the RAM-disk. For large register books which contain more than 64 records, a 16 KB "cache" memory is implemented in order to be able to move back and forth while reading the records. Notice, that in the 2025 version, in order to maximize the free directory entries and to overcome the Compiler and Editor Overflow, a big part of the On File source code (ONFILE.COM) has been '''encapsulated in the source code''' of the Register Book (REGISTER.COM) and is accessed upon user request via boolean expressions that are temporarily stored in the RAM-disk<ins style="font-weight: bold; text-decoration: none;">. </ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">What gap does On File (2025) come to fill? Let’s give an example.</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">Using On File Register, a register book can be set up with, for example, 5000 citizens of a small town. The Register Book is saved on disk (disk 0) and is loaded in RAM of the CPC6128. Then, using On File Database, a full-screen record can be created for each citizen. The records of the database are saved on 26 different disks (disks A-Z), depending on the surname of each resident. The register book is loaded (from disk 0) into memory once and remains there until the end of the work regardless of which disk (A-Z) is in drive B. Upon exit, the contents of the RAM (Register book, if modified) are saved on disk 0. This can be achieved with an Amstrad CPC6128 with 512 KB RAM expansion and 800 KB external floppy drive</ins>. </div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
</table>KSLhttps://wiki.amstrad-cpc.net/index.php?title=On_File&diff=121861&oldid=prevKSL at 08:02, 4 June 20252025-06-04T08:02:07Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw-interface="">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 08:02, 4 June 2025</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l7">Line 7:</td>
<td colspan="2" class="diff-lineno">Line 7:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>'''On File (2024)''' Database Management System was released in June 2024 by [[KSL]] in order to celebrate the anniversaries of CPC (40 years!) and CP/M-80 (50 years!). On File is a business application similar to the MSDOS-era PC applications and one of the most recent projects developed for '''CP/M 2.2'''. As per [[Cosmos]], On File has been developed on the basis of all the hardware peripherals as well as the software that were (contemporary) available for the CP/M and the CPC6128. However, it can run on a standard single drive CPC6128. On File database is efficient, quick and reliable and can be used on an everyday basis using the CPC emulators. On File database uses the entire CPC screen as the platform for the records; thus there is plenty of space to edit user-defined fields. In addition, a wide variety of characters and symbols can be included in the fileds, hence the records can contain data beyond the typical and traditional text type. Setting up a new database using On File database is very easy and can be performed in three steps: 1) start the new file system by resetting the database and the master record, 2) frame/draw and edit the structure of the master record, 3) append new records in the database on the basis of the master record. On File database is fully dynamic, thus the user can modify the master record as well as any record anytime. Furthermore, the database can be either flat or relational. On File database has maximum capacity of 200 records (400 KB). The original disk (2024) contains the boot sectors for CP/M 2.2 (Dobbertin v1.2 for 128 KB machines), a few demo master records (*.002 files), a few database examples, the application (COM file), as well as the color screen saver (CHN file).</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>'''On File (2024)''' Database Management System was released in June 2024 by [[KSL]] in order to celebrate the anniversaries of CPC (40 years!) and CP/M-80 (50 years!). On File is a business application similar to the MSDOS-era PC applications and one of the most recent projects developed for '''CP/M 2.2'''. As per [[Cosmos]], On File has been developed on the basis of all the hardware peripherals as well as the software that were (contemporary) available for the CP/M and the CPC6128. However, it can run on a standard single drive CPC6128. On File database is efficient, quick and reliable and can be used on an everyday basis using the CPC emulators. On File database uses the entire CPC screen as the platform for the records; thus there is plenty of space to edit user-defined fields. In addition, a wide variety of characters and symbols can be included in the fileds, hence the records can contain data beyond the typical and traditional text type. Setting up a new database using On File database is very easy and can be performed in three steps: 1) start the new file system by resetting the database and the master record, 2) frame/draw and edit the structure of the master record, 3) append new records in the database on the basis of the master record. On File database is fully dynamic, thus the user can modify the master record as well as any record anytime. Furthermore, the database can be either flat or relational. On File database has maximum capacity of 200 records (400 KB). The original disk (2024) contains the boot sectors for CP/M 2.2 (Dobbertin v1.2 for 128 KB machines), a few demo master records (*.002 files), a few database examples, the application (COM file), as well as the color screen saver (CHN file).</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>'''On File (2025)''' Database Management System for '''CP/M plus''' was released in June 2025. In addition to the 2024 version, it includes the options to Group and to Invert the records, to Index the database, to perform Index based search and to perform field based sum calculations. It also supports [[GSX]], '''field-based graphics''', unlimited number of relational keys and On Board help. It also includes '''On File Register''', a RAM-disk based register book. The latter provides capacity for a few thousands of single-field records. Hence, the user can set up e.g. a Register of Earthquakes (date, time, location, magnitude, depth, duration) using On File Register, while keeping detailed records of specific earthquakes (e.g. > 6 R) using On File Database. On File 2025 requires RAM expansion to run and includes a resume option in order to access the RAM-disk contents upon restart. The original disk contains CP/M plus (Dobbertin v1.1x) boot sectors, a database of old computers and a register book for the period 1970-1980.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>'''On File (2025)''' Database Management System for '''CP/M plus''' was released in June 2025. In addition to the 2024 version, it includes the options to Group and to Invert the records, to Index the database, to perform Index based search and to perform field based sum calculations. It also supports [[GSX]], '''field-based graphics''', unlimited number of relational keys and On Board help. It also includes '''On File Register''', a RAM-disk based register book. The latter provides capacity for a few thousands of single-field records. Hence, the user can set up e.g. a Register of Earthquakes (date, time, location, magnitude, depth, duration) using On File Register, while keeping detailed records of specific earthquakes (e.g. > 6 R) using On File Database. On File 2025 requires RAM expansion to run and includes a resume option in order to access the RAM-disk contents upon restart. The original disk contains CP/M plus (Dobbertin v1.1x) boot sectors, a database of old computers and a register book for the period 1970-1980<ins style="font-weight: bold; text-decoration: none;">. On File database (2024/2025) is disk-based, thus all the records are stored in the disk drive as stand-alone files. On the other hand, On File Register uses a single file to store the records in the RAM-disk. For large register books which contain more than 64 records, a 16 KB "cache" memory is implemented in order to be able to move back and forth while reading the records. Notice, that in the 2025 version, in order to maximize the free directory entries and to overcome the Compiler and Editor Overflow, a big part of the On File source code (ONFILE.COM) has been '''encapsulated in the source code''' of the Register Book (REGISTER.COM) and is accessed upon user request via boolean expressions that are temporarily stored in the RAM-disk</ins>. </div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>On <del style="font-weight: bold; text-decoration: none;">File database </del>(2024<del style="font-weight: bold; text-decoration: none;">/2025</del>) <del style="font-weight: bold; text-decoration: none;">is disk-based, thus all the records are stored in the disk drive as stand-alone files. On the other hand, On File Register uses a single file to store the records in the RAM-disk. For large register books which contain more than 64 records, a 16 KB "cache" memory is implemented in order to be able to move back and forth while reading the records. Notice, that in the 2025 version, in order to maximize the free directory entries </del>and <del style="font-weight: bold; text-decoration: none;">to overcome the Compiler and Editor Overflow, a big part of the </del>On File <del style="font-weight: bold; text-decoration: none;">source code </del>(<del style="font-weight: bold; text-decoration: none;">ONFILE.COM</del>) <del style="font-weight: bold; text-decoration: none;">has been '''encapsulated in the source code''' of the Register Book (REGISTER.COM) and is accessed upon user request via boolean expressions that are temporarily stored in the RAM-disk</del>. </div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">Using the following two links you can download </ins>On <ins style="font-weight: bold; text-decoration: none;">FIle </ins>(2024) and On File (<ins style="font-weight: bold; text-decoration: none;">2025</ins>) <ins style="font-weight: bold; text-decoration: none;">respectively</ins>.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Download ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Download ==</div></td></tr>
</table>KSLhttps://wiki.amstrad-cpc.net/index.php?title=On_File&diff=121860&oldid=prevKSL at 19:18, 3 June 20252025-06-03T19:18:05Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw-interface="">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 19:18, 3 June 2025</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l5">Line 5:</td>
<td colspan="2" class="diff-lineno">Line 5:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Image:OnFile_2025_CPC6128_Record.jpg|right|thumb|250px|On File (2025) CPC6128 record which also includes field-based graphics]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Image:OnFile_2025_CPC6128_Record.jpg|right|thumb|250px|On File (2025) CPC6128 record which also includes field-based graphics]]</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>'''On File (2024)''' Database Management System was released in June 2024 by [[KSL]] in order to celebrate the anniversaries of CPC (40 years!) and CP/M-80 (50 years!). On File is a business application similar to the MSDOS-era PC applications and one of the most recent projects developed for CP/M 2.2. As per [[Cosmos]], On File has been developed on the basis of all the hardware peripherals as well as the software that were (contemporary) available for the CP/M and the CPC6128. However, it can run on a standard single drive CPC6128. On File database is efficient, quick and reliable and can be used on an everyday basis using the CPC emulators. On File database uses the entire CPC screen as the platform for the records; thus there is plenty of space to edit user-defined fields. In addition, a wide variety of characters and symbols can be included in the fileds, hence the records can contain data beyond the typical and traditional text type. Setting up a new database using On File database is very easy and can be performed in three steps: 1) start the new file system by resetting the database and the master record, 2) frame/draw and edit the structure of the master record, 3) append new records in the database on the basis of the master record. On File database is fully dynamic, thus the user can modify the master record as well as any record anytime. Furthermore, the database can be either flat or relational. On File database has maximum capacity of 200 records (400 KB). The original disk (2024) contains the boot sectors for CP/M 2.2 (Dobbertin v1.2 for 128 KB machines), a few demo master records (*.002 files), a few database examples, the application (COM file), as well as the color screen saver (CHN file).</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>'''On File (2024)''' Database Management System was released in June 2024 by [[KSL]] in order to celebrate the anniversaries of CPC (40 years!) and CP/M-80 (50 years!). On File is a business application similar to the MSDOS-era PC applications and one of the most recent projects developed for <ins style="font-weight: bold; text-decoration: none;">'''</ins>CP/M 2.2<ins style="font-weight: bold; text-decoration: none;">'''</ins>. As per [[Cosmos]], On File has been developed on the basis of all the hardware peripherals as well as the software that were (contemporary) available for the CP/M and the CPC6128. However, it can run on a standard single drive CPC6128. On File database is efficient, quick and reliable and can be used on an everyday basis using the CPC emulators. On File database uses the entire CPC screen as the platform for the records; thus there is plenty of space to edit user-defined fields. In addition, a wide variety of characters and symbols can be included in the fileds, hence the records can contain data beyond the typical and traditional text type. Setting up a new database using On File database is very easy and can be performed in three steps: 1) start the new file system by resetting the database and the master record, 2) frame/draw and edit the structure of the master record, 3) append new records in the database on the basis of the master record. On File database is fully dynamic, thus the user can modify the master record as well as any record anytime. Furthermore, the database can be either flat or relational. On File database has maximum capacity of 200 records (400 KB). The original disk (2024) contains the boot sectors for CP/M 2.2 (Dobbertin v1.2 for 128 KB machines), a few demo master records (*.002 files), a few database examples, the application (COM file), as well as the color screen saver (CHN file).</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>'''On File (2025)''' Database Management System for CP/M plus was released in June 2025. In addition to the 2024 version, it includes the options to Group and to Invert the records, to Index the database, to perform Index based search and to perform field based sum calculations. It also supports [[GSX]], '''field-based graphics''', unlimited number of relational keys and On Board help. It also includes '''On File Register''', a RAM-disk based register book. The latter provides capacity for a few thousands of single-field records. Hence, the user can set up e.g. a Register of Earthquakes (date, time, location, magnitude, depth, duration) using On File Register, while keeping detailed records of specific earthquakes (e.g. > 6 R) using On File Database. On File 2025 requires RAM expansion to run and includes a resume option in order to access the RAM-disk contents upon restart. The original disk contains CP/M plus (Dobbertin v1.1x) boot sectors, a database of old computers and a register book for the period 1970-1980.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>'''On File (2025)''' Database Management System for <ins style="font-weight: bold; text-decoration: none;">'''</ins>CP/M plus<ins style="font-weight: bold; text-decoration: none;">''' </ins>was released in June 2025. In addition to the 2024 version, it includes the options to Group and to Invert the records, to Index the database, to perform Index based search and to perform field based sum calculations. It also supports [[GSX]], '''field-based graphics''', unlimited number of relational keys and On Board help. It also includes '''On File Register''', a RAM-disk based register book. The latter provides capacity for a few thousands of single-field records. Hence, the user can set up e.g. a Register of Earthquakes (date, time, location, magnitude, depth, duration) using On File Register, while keeping detailed records of specific earthquakes (e.g. > 6 R) using On File Database. On File 2025 requires RAM expansion to run and includes a resume option in order to access the RAM-disk contents upon restart. The original disk contains CP/M plus (Dobbertin v1.1x) boot sectors, a database of old computers and a register book for the period 1970-1980.</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>On File database (2024/2025) is disk-based, thus all the records are stored in the disk drive as stand-alone files. On the other hand, On File Register uses a single file to store the records in the RAM-disk. For large register books which contain more than 64 records, a 16 KB "cache" memory is implemented in order to be able to move back and forth while reading the records. Notice, that in the 2025 version, in order to maximize the free directory entries and to overcome the Compiler and Editor Overflow, a big part of the On File source code (ONFILE.COM) has been '''encapsulated in the source code''' of the Register Book (REGISTER.COM) and is accessed upon user request via boolean expressions that are temporarily stored in the RAM-disk. </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>On File database (2024/2025) is disk-based, thus all the records are stored in the disk drive as stand-alone files. On the other hand, On File Register uses a single file to store the records in the RAM-disk. For large register books which contain more than 64 records, a 16 KB "cache" memory is implemented in order to be able to move back and forth while reading the records. Notice, that in the 2025 version, in order to maximize the free directory entries and to overcome the Compiler and Editor Overflow, a big part of the On File source code (ONFILE.COM) has been '''encapsulated in the source code''' of the Register Book (REGISTER.COM) and is accessed upon user request via boolean expressions that are temporarily stored in the RAM-disk. </div></td></tr>
</table>KSLhttps://wiki.amstrad-cpc.net/index.php?title=On_File&diff=121859&oldid=prevKSL at 19:13, 3 June 20252025-06-03T19:13:38Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw-interface="">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 19:13, 3 June 2025</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Image:On_File_Main_Menu.jpg|right|thumb|250px|On File (2024) main menu]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Image:On_File_Main_Menu.jpg|right|thumb|250px|On File (2024) main menu]]</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Image:On_File_typical_record.jpg|right|thumb|250px|On File fuel consumption record]]</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Image:On_File_typical_record.jpg|right|thumb|250px|On File <ins style="font-weight: bold; text-decoration: none;">(2024) </ins>fuel consumption record]]</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Image:On_File_Car_Maintenance_Record.jpg|right|thumb|250px|On File car maintenance record]]</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Image:On_File_Car_Maintenance_Record.jpg|right|thumb|250px|On File <ins style="font-weight: bold; text-decoration: none;">(2024) </ins>car maintenance record]]</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Image:OnFile_2025_Main_Menu.jpg|right|thumb|250px|On File (2025) main menu (containing 200 records, 1640 registrations)]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Image:OnFile_2025_Main_Menu.jpg|right|thumb|250px|On File (2025) main menu (containing 200 records, 1640 registrations)]]</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Image:OnFile_2025_CPC6128_Record.jpg|right|thumb|250px|On File (2025) CPC6128 record which also includes field-based graphics]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Image:OnFile_2025_CPC6128_Record.jpg|right|thumb|250px|On File (2025) CPC6128 record which also includes field-based graphics]]</div></td></tr>
</table>KSLhttps://wiki.amstrad-cpc.net/index.php?title=On_File&diff=121858&oldid=prevKSL at 19:13, 3 June 20252025-06-03T19:13:12Z<p></p>
<table style="background-color: #fff; color: #202122;" data-mw-interface="">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 19:13, 3 June 2025</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l3">Line 3:</td>
<td colspan="2" class="diff-lineno">Line 3:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Image:On_File_Car_Maintenance_Record.jpg|right|thumb|250px|On File car maintenance record]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Image:On_File_Car_Maintenance_Record.jpg|right|thumb|250px|On File car maintenance record]]</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Image:OnFile_2025_Main_Menu.jpg|right|thumb|250px|On File (2025) main menu (containing 200 records, 1640 registrations)]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[Image:OnFile_2025_Main_Menu.jpg|right|thumb|250px|On File (2025) main menu (containing 200 records, 1640 registrations)]]</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Image:OnFile_2025_CPC6128_Record.jpg|right|thumb|250px|On File (2025) CPC6128 record]]</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Image:OnFile_2025_CPC6128_Record.jpg|right|thumb|250px|On File (2025) CPC6128 record <ins style="font-weight: bold; text-decoration: none;">which also includes field-based graphics</ins>]]</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>'''On File (2024)''' Database Management System was released in June 2024 by [[KSL]] in order to celebrate the anniversaries of CPC (40 years!) and CP/M-80 (50 years!). On File is a business application similar to the MSDOS-era PC applications and one of the most recent projects developed for CP/M 2.2. As per [[Cosmos]], On File has been developed on the basis of all the hardware peripherals as well as the software that were (contemporary) available for the CP/M and the CPC6128. However, it can run on a standard single drive CPC6128. On File database is efficient, quick and reliable and can be used on an everyday basis using the CPC emulators. On File database uses the entire CPC screen as the platform for the records; thus there is plenty of space to edit user-defined fields. In addition, a wide variety of characters and symbols can be included in the fileds, hence the records can contain data beyond the typical and traditional text type. Setting up a new database using On File database is very easy and can be performed in three steps: 1) start the new file system by resetting the database and the master record, 2) frame/draw and edit the structure of the master record, 3) append new records in the database on the basis of the master record. On File database is fully dynamic, thus the user can modify the master record as well as any record anytime. Furthermore, the database can be either flat or relational. On File database has maximum capacity of 200 records (400 KB). The original disk (2024) contains the boot sectors for CP/M 2.2 (Dobbertin v1.2 for 128 KB machines), a few demo master records (*.002 files), a few database examples, the application (COM file), as well as the color screen saver (CHN file).</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>'''On File (2024)''' Database Management System was released in June 2024 by [[KSL]] in order to celebrate the anniversaries of CPC (40 years!) and CP/M-80 (50 years!). On File is a business application similar to the MSDOS-era PC applications and one of the most recent projects developed for CP/M 2.2. As per [[Cosmos]], On File has been developed on the basis of all the hardware peripherals as well as the software that were (contemporary) available for the CP/M and the CPC6128. However, it can run on a standard single drive CPC6128. On File database is efficient, quick and reliable and can be used on an everyday basis using the CPC emulators. On File database uses the entire CPC screen as the platform for the records; thus there is plenty of space to edit user-defined fields. In addition, a wide variety of characters and symbols can be included in the fileds, hence the records can contain data beyond the typical and traditional text type. Setting up a new database using On File database is very easy and can be performed in three steps: 1) start the new file system by resetting the database and the master record, 2) frame/draw and edit the structure of the master record, 3) append new records in the database on the basis of the master record. On File database is fully dynamic, thus the user can modify the master record as well as any record anytime. Furthermore, the database can be either flat or relational. On File database has maximum capacity of 200 records (400 KB). The original disk (2024) contains the boot sectors for CP/M 2.2 (Dobbertin v1.2 for 128 KB machines), a few demo master records (*.002 files), a few database examples, the application (COM file), as well as the color screen saver (CHN file).</div></td></tr>
</table>KSL