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!).<br> 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[[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: the 512 KB [[Dobbertin Memory Expansion]]. 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 [[ParaDOS]] or [[X-DDOS]] ROMS CPC emulators. It uses the entire CPC screen as the platform for the external (800 KB) floppy driverecords; 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 20 MB [[Dobbertin Harddisc]]fileds, hence the [[Amstrad Serial Interface]], records can contain data beyond the Amstrad Parallel [[Printer Port]]typical and traditional text type. On File database is fully dynamic, thus the [[CTM640/CTM644]] colour monitor, user can modify the [[AMX Mouse]]master record as well as any record anytime. Furthermore, the [[MicroScript]] database can be either flat or relational. On File (2024) database has maximum capacity of 200 records (142 400 KB), . The original disk contains the [[WordStar]] boot sectors for CP/M 2.2 (706 Dobbertin v1.2 for 128 KBRAM), the [[Protext]] a few demo master records (406 KB*.002 files), a few database examples, the [[Multiplan]] application (208 KBCOM file), as well as the [[SuperCalc 2]] color screen saver (240 KBCHN file). '''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 [[dBase IIGSX]] , '''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 (272 KBDobbertin v1.1x), a database of old computers and a register book for the [[DR Draw]] period 1970-1989. On File database (235 KB2024/2025)is disk-based, thus all the [[DR Graph]] (306 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 [[MAXAM]] 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 (206 KBONFILE.COM), has been '''encapsulated in the [[Atlast Plus]] source code''' of the Register Book (224 KBREGISTER.COM) and other [[Programming software]]is accessed upon user request via boolean expressions that are temporarily stored in the RAM-disk.  What gap of the 80's does On File includes its own graphics routines (similar to [[GSX]]2025)come to fill? Let’s give a “professional” example. Using On File Register, is based on a register book of earthquakes that are realized in a specific country can be set up, including Serial Number, Date, Time, Location, Duration, Depth and Magnitude. Then using On File Database, detailed records of the [[Dobbertin]] earthquakes that where stronger than e.g. 5 Richter can be set up including the map of their location. 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 2.2 plus (v1.21x) which provides 59 KB TPA, supports RamDOS D20 disks or HD20. Using the RAM expansion following two links you can download On FIle (2024) and the 20 MB hard diskOn File (2025) respectively. <br><br>

[[Category:Applications]] [[Category:CP/M]]  == Download ==* [http://www.cpcwiki.eu/index.php/File:On_File_2025_Boot_Disk.dsk Download from CPCWiki] [[Category:Applications]] [[Category:CP/M]]