Changes

[[Image:On_File_Main_Menu.jpg|right|thumb|250px|On File (2024) main menu]][[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/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. 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. 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 (2024) projects developed database has maximum capacity of 200 records (400 KB). The original disk contains the boot sectors for CP/M2.2 (Dobbertin v1.2 for 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 database is quick and reliable. It uses the entire CPC screen as the platform (2025)''' Database Management System for the records; thus there is plenty of space to store large amount of data'''CP/M plus''' was released in June 2025. In additionto the 2024 version, a wide variety of characters it includes the options to Group and symbols can be included in to Invert the records, hence to Index the database can contain data beyond the typical , to perform Index based search and traditional text typeto perform field based calculations. Setting up It also supports [[GSX]], '''field-based graphics''', unlimited number of Relational Keys and On Board help. It also includes '''On File Register''', a new database using RAM-disk based register book. The latter provides capacity for a few thousands of single-field records. On File is very easy 2025 requires RAM expansion to run and can be performed includes a resume option in three steps: 1) start order to access the new file system by resetting the database and the master record, 2) frameRAM-disk contents upon restart. The original disk contains CP/draw and edit the structure of the master record, 3M plus boot sectors (Dobbertin v1.1x) append new records in the , a database on the basis of old computers and a register book for the master recordperiod 1970-1989. The On File database (2024/2025) is fully dynamicdisk-based, thus all the user can modify records are stored in the master record as well disk drive as any record anytimestand-alone files. FurthermoreOn the other hand, On File Register uses a single file to store the database can be either flat or relationalrecords in the RAM-disk. Children For large register books which contain more than 64 records include , a 16 KB "cache" memory is implemented in order to be able to move back and forth while reading the ^ symbol followed by records. Notice, that in the relational key and one space2025 version, for example ^Z80 . Parent records include in order to maximize the relational key (not free directory entries and to overcome the ^ symbol) followed by one space, for example Z80 . As per [[Cosmos]]Compiler and Editor Overflow, a big part of the On File source code (ONFILE.COM) has been developed on '''encapsulated in the basis source code''' of all the hardware peripherals as well as the software that were Register Book (contemporaryREGISTER.COM) available for the CP/M and is accessed upon user request via boolean expressions that are temporarily stored in the CPC6128. The original RAM-disk contains some demo master records (*.002 files), some demo records as well as the boot sectors for CP/M 2.2 (v1.2).

What gap of the 80'''s does On File Register Book''' (On File extension) will be released in summer 2025) come to fill? Let’s give an example. ThusUsing On File Register, the user a register book can be set up a Register with, for example, 5000 citizens of ea town.g Earthquakes The register book (date, time, location, magnitude, depth~210 KB) is saved in disk (disk 0) and is loaded once in the RAM of the CPC6128. Then, using On File RegisterDatabase, while keeping detailed a full-screen record can be created for each citizen. The records of the ones that were stronger than e.g. 6 R using On Filedatabase are saved in 26 different disks (disks A-Z or HD20), depending on the surname of each resident. As per [[Cosmos]]Notice, On File Register has a resume option that the register book remains in order to access RAM until the end of the work regardless of which disk (A-Z/HD20) 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 contents anytime and it also supports , a 800 KB external floppy drive, the On File screen saverspecific version of CP/M plus (v1.1x), RamDOS D20 disks or HD20.

Using the following two links you can download On File database is disk-based FIle (2024) and every record has its own unique filename, stored in the disk drive. On File capacity is 200 screen records (equal to 400 KB2025), it is thus an ideal application for the 20 MB [[Dobbertin Harddisc]] which supports up to 512 file entries as well as [[ROMDOS]] or [[ParaDOS]] 80 track disks. On the other hand, On File Register Book is RAM-based and single filed, thus it provides practically endless capacity for 128 byte recordsrespectively.

* [http://www.cpcwiki.eu/index.php/File:On_File_2024_Boot_DiskOn_File_2025_Boot_Disk.dsk Download from CPCWiki]