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 (2024) 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 reliableand 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. Setting up a new database using On File is very easy and can be performed in three steps: <br><br> 1) start the new file system by resetting the database and the master record, <br> 2) frame/draw and edit the structure of the master record, <br> 3) append new records in the database on the basis of the master record. <br><br> The 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 is disk-based and has a maximum capacity of 200 records (400 KB). The original disk contains some demo master records (*.002 files), some demo records (*.REC files) as well as the boot sectors for CP/M 2.2 (Dobbertin v1.2). <br><br> In summer 2025 a new version of On File will be released. It will provide capacity for 230 records (460 128 KBRAM) and will also include '''On File Register''', a RAM-disk single-file register book. The latter will provide capacity for a few thousands of single-field demo master records(*. Hence002 files), a few database examples, the user can set up e.g. a Register of Earthquakes application (date, time, location, magnitude, depth and durationCOM file) using On File Register, while keeping detailed records of as well as the earthquakes that were stronger than e.g. 6 Richter using On File Database. As per [[Cosmos]], On File Register has a resume option in order to access the RAM-disk contents anytime and it also supports the On File color screen saver(CHN file).

What gap of the 80's does On File is (2025) come to fill? Let’s give an ideal application for the [[ROMDOS]] D20 80 track disksexample. Using On File Register, which a register book can store be set up to 256 files in with, for example, 5000 citizens of a single directory user town. The register book (tested ~210 KB) is saved in disk (disk 0) and working is loaded once in the RAM of the CPC6128. Then, using On File 2025)Database, a full-screen record can be created for each citizen. The 20 MB [[Dobbertin Harddisc]] records of the database are saved in 26 different disks (disks A-Z or similar media HD20), depending on the surname of each resident. Notice, that the register book remains in RAM until the end of the work regardless of which support up to 512 directory entries can also be disk (A-Z/HD20) is used. The amount Upon exit, the contents of data that the RAM (register book, if modified) are saved in disk 0. This can be stored and accessed using On File and On File Register is huge for achieved with an Amstrad CPC6128 with 512 KB RAM expansion, a 800 KB external floppy drive, the specific version of CP/M-80 worldplus (v1.1x), RamDOS D20 disks or HD20.

 '''Good applications are like good songs, they never dieUsing the following two links you can download On FIle (2024) and On File (2025) respectively.'''