Changes

[[Image:On_File_typical_record.jpg|right|thumb|250px|On File (2024) fuel consumption record]][[Image:On_File_Car_Maintenance_Record.jpg|right|thumb|250px|On File (2024) car maintenance record]][[Image:OnFile_2025_Main_Menu.jpg|right|thumb|250px|On File (2025) main menu (containing 200 records, 1640 registrations)]][[Image:OnFile_2025_CPC6128_Record.jpg|right|thumb|250px|On File (2025) CPC6128 record which also includes field-based graphics]]

'''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/M2.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 It 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. Children records include the ^ symbol followed by the relational key and one space, for example ^Z80 . Parent records include the relational key On File (not the ^ symbol2024) followed by one space, for example Z80 . 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.2for 128 KB RAM), a few demo master records (*.002 files), a few database examples, the application (COM file), as well as the color screen saver(CHN file).

'''On File (2025)''' Database Management System will be for '''CP/M plus''' was released in summer June 2025 and will include . In addition to the 2024 version, it includes the options to Group and to Invert the records, to index Index the database, to perform index Index based search and support for to perform field based calculations. It also supports [[GSX]], '''field-based graphics''', unlimited number of Relational Keys and On Board help. It wil also include includes '''On File Register''', a RAM-disk based register book. The latter will provide provides capacity for a few thousands of single-field records. Hence, On File 2025 requires RAM expansion to run and includes a resume option in order to access the user can set up eRAM-disk contents upon restart.gThe original disk contains CP/M plus boot sectors (Dobbertin v1. 1x), a Register database of Earthquakes old computers and a register book for the period 1970-1989. On File database (date2024/2025) is disk-based, time, locationthus all the records are stored in the disk drive as stand-alone files. On the other hand, magnitude, depth, duration) using On File Registeruses 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 keeping detailed 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 specific earthquakes the On File source code (e.gONFILE. > 6 RCOM) using On File Databasehas been '''encapsulated in the source code''' of the Register Book (REGISTER. On File 2025 requires RAM expansion to run COM) and has a resume option is accessed upon user request via boolean expressions that are temporarily stored in order to access the RAM-disk contents upon restart.

What gap of the 80's does On File database (2024/2025) is disk-based, thus all the records are stored in the disk drive as stand-alone filescome to fill? Let’s give an example. On the other hand, Using On File Register uses , a single file to store the records in the RAM-disk. For large register books which contain more than 64 recordsbook can be set up with, for example, 5000 citizens of a 16 town. The register book (~210 KB "cache" memory ) is implemented saved in order to be able to move back disk (disk 0) and forth while reading 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 recordsof the database are saved in 26 different disks (disks A-Z or HD20), depending on the surname of each resident. Notice, that in the 2025 version, register book remains in order to maximize RAM until the free directory entries and to overcome end of the Compiler and Editor Overflowwork regardless of which disk (A-Z/HD20) is used. Upon exit, a big part the contents of the On File source code RAM (ONFILE.COMregister book, if modified) has been '''encapsulated 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 source code''' specific version of the Register Book CP/M plus (REGISTERv1.COM1x) and is accessed upon user request via boolean expressions that are temporarily stored in , RamDOS D20 disks or HD20.  Using the RAM-diskfollowing two links you can download On FIle (2024) and On File (2025) respectively.