Changes

'''[[Image:On_File_Main_Menu.jpg|right|thumb|250px|On File''' Database Management System was released in June (2024 by ) main menu]][[KSLImage:On_File_typical_record.jpg|right|thumb|250px|On File (2024) fuel consumption record]] in order to celebrate the anniversaries of CPC [[Image:On_File_Car_Maintenance_Record.jpg|right|thumb|250px|On File (40 years!2024) and CP/M-80 car maintenance record]][[Image:OnFile_2025_Main_Menu.jpg|right|thumb|250px|On File (50 years!2025).main menu (containing 200 records, 1640 registrations)]]<br>[[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: the 512 KB [[Dobbertin Memory Expansion]]. However, the [[ParaDOS]] or [[X-DDOS]] ROMS for the external (800 KB) floppy it can run on a standard single driveCPC6128. On File database is efficient, quick and reliable and can be used on an everyday basis using the 20 MB [[Dobbertin Harddisc]], CPC emulators. It uses the [[Amstrad Serial Interface]], entire CPC screen as the Amstrad Parallel [[Printer Port]], platform for the [[CTM640/CTM644]] colour monitorrecords; 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 [[AMX Mouse]]fileds, hence the [[MicroScript]] (142 KB), records can contain data beyond the [[WordStar]] (706 KB)typical and traditional text type. On File database is fully dynamic, thus the [[Protext]] (406 KB), user can modify the [[Multiplan]] (208 KB)master record as well as any record anytime. Furthermore, the [[SuperCalc 2]] database can be either flat or relational. On File (240 KB2024), the [[dBase II]] database has maximum capacity of 200 records (272 400 KB), . The original disk contains the [[DR Draw]] boot sectors for CP/M 2.2 (235 Dobbertin v1.2 for 128 KBRAM), the [[DR Graph]] a few demo master records (306 KB*.002 files), the [[MAXAM]] (206 KB)a few database examples, the [[Atlast Plus]] application (224 KB) and other [[Programming software]]. On File includes its own graphics routines (similar to [[GSX]]COM file), is based on as well as the [[Dobbertin]] version of CP/M 2.2 color screen saver (v1.2CHN file) which provides 59 KB TPA, supports the RAM expansion and the 20 MB hard disk. <br><br>

'''On File is quick (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 reliableto Invert the records, to Index the database, to perform Index based search and to perform field based calculations. It uses also supports [[GSX]], '''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 CPC screen RAM-disk contents upon restart. The original disk contains CP/M plus boot sectors (80x25Dobbertin v1.1x) as , a single record; thus there is plenty database of space to edit many different fields old computers and store large amount of dataa register book for the period 1970-1989. Every screen On File database (record2024/2025) is disk-based, thus all the records are stored automatically in the disk with a different name, so that it can be accessed by drive as stand-alone files. On the other programshand, like word processors. In order to set up On File Register uses a new database: 1) Start a new single file system by resetting to store the database and records in the master recordRAM-disk. 2) Frame 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/or draw forth while reading the master recordrecords. 3) Edit Notice, that in the fields 2025 version, in order to maximize the free directory entries and to overcome the structure Compiler and Editor Overflow, a big part of the master recordOn File source code (ONFILE. 4COM) Append the records has been '''encapsulated in the database on the basis source code''' of the master recordRegister Book (REGISTER.COM) and is accessed upon user request via boolean expressions that are temporarily stored in the RAM-disk.

Relations: The database What gap of the 80's does On File (2025) come to fill? Let’s give an example. Using On File Register, a register book can be either flat or relational. Children records include the ^ symbol followed by the relational key and one spaceset up with, for example ^Z80 , 5000 citizens of a town. The relational key can contain up to 15 symbols register book (A~210 KB) is saved in disk (disk 0) and is loaded once in the RAM of the CPC6128..ZThen, using On File Database, afull-screen record can be created for each citizen..z, 1..0,+,?, etc.). Parent The records include of the relational key database are saved in 26 different disks (not the ^ symboldisks A-Z or HD20) followed by one space, for example Z80 depending on the surname of each resident. If a record contains more than one relational keyNotice, that the key at register book remains in RAM until the lowest field is set as end of the active keywork regardless of which disk (A-Z/HD20) is used. In case Upon exit, the contents of large databases move the parent records at RAM (register book, if modified) 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 start specific version of the database listCP/M plus (v1.1x), RamDOS D20 disks or HD20.

Notes: Using the following two links you can download On File capacity is 200 records FIle (equal to 400 KB2024). The original disk contains some demo master records and On File (*.002 files2025) as well as the boot sectors for CP/M 2respectively.2 (v1.2)

[[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]]