[[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 typical (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). <br>
As per [[Cosmos]], '''On File has been developed on the basis of the hardware peripherals as well as the software that were (contemporary2025) available ''' Database Management System for the '''CP/M and plus''' was released in June 2025. In addition to the CPC6128: the 512 KB [[Dobbertin Memory Expansion]]2024 version, it includes the [[ParaDOS]] or [[X-DDOS]] ROMS for options to Group and to Invert the external (800 KB) floppy driverecords, to Index the 20 MB [[Dobbertin Harddisc]]database, the to perform Index based search and to perform field based calculations. It also supports [[Amstrad Serial InterfaceGSX]], the Amstrad Parallel [[Printer Port]]'''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 [[CTM640RAM-disk contents upon restart. The original disk contains CP/CTM644]] colour monitor, the [[AMX Mouse]], the [[MicroScript]] M plus boot sectors (142 KBDobbertin v1.1x), a database of old computers and a register book for the [[WordStar]] period 1970-1989. On File database (706 KB2024/2025)is disk-based, thus all the [[Protext]] (406 KB), records are stored in the [[Multiplan]] (208 KB)disk drive as stand-alone files. On the other hand, On File Register uses a single file to store the [[SuperCalc 2]] (240 KB)records in the RAM-disk. For large register books which contain more than 64 records, the [[dBase II]] (272 a 16 KB), "cache" memory is implemented in order to be able to move back and forth while reading the [[DR Draw]] (235 KB)records. Notice, that in the [[DR Graph]] (306 KB)2025 version, in order to maximize the [[MAXAM]] (206 KB)free directory entries and to overcome the Compiler and Editor Overflow, a big part of the [[Atlast Plus]] On File source code (224 KBONFILE.COM) and other [[Programming software]]. On File includes a graphics screen saver, is based on has been '''encapsulated in the [[Dobbertin]] version source code''' of CP/M 2.2 the Register Book (v1REGISTER.2COM) which provides 59 KB TPA, supports and is accessed upon user request via boolean expressions that are temporarily stored in the RAM expansion and the 20 MB hard -disk. <br>
What gap of the 80's does On File database is disk-based, quick and reliable. It uses the CPC screen (80x252025) as come to fill? Let’s give a single record; thus there is plenty “professional” example. Using On File Register, a register book of space to edit many different fields earthquakes that are realized in a specific country can be set up, including Serial Number, Date, Time, Location, Duration, Depth and store large amount of dataMagnitude. Setting up a new database Then using On File is very easy: 1) start the new file system by resetting the database and the master recordDatabase, 2) frame and/or draw the master record, 3) edit the fields and the structure detailed records of the master record, 4) append earthquakes that where stronger than e.g. 5 Richter can be set up including the records in the database on the basis map of the master recordtheir location. Every record has its own unique filename This can be achieved with an Amstrad CPC6128 with 512 KB RAM expansion, a 800 KB external floppy drive, stored in the disk drivespecific version of CP/M plus (v1. On File capacity is 200 records (equal to 400 KB1x), it is thus ideal for the 20 MB [[Dobbertin Harddisc]] which supports up to 512 file entriesRamDOS D20 disks or HD20.
The database can be either flat or relational. Children records include Using the ^ symbol followed by the relational key and one space, for example ^Z80 . The relational key following two links you can contain up to 15 symbols download On FIle (A..Z, a..z, 1..0,+,?, etc.2024). Parent records include the relational key and On File (not the ^ symbol2025) followed by one space, for example Z80 respectively. If a record contains more than one relational key, the key at the lowest field is set as the active key. The original disk contains some demo master records (*.002 files) as well as the boot sectors for CP/M 2.2 (v1.2)
== Download ==
* [http://www.cpcwiki.eu/index.php/File:On_File_2024_Boot_Disk.dsk Download from CPCWiki]
[[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]]