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). <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]] (224 KB) and other [[Programming software]]. On File includes its own graphics routines source code (similar to [[GSX]]ONFILE.COM), 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 is quick and reliable. It uses the CPC screen (80x252025) as come to fill? Let’s give an example. Using On File Register, a single record; thus there is plenty register book can be set up with, for example, 5000 citizens of space to edit many different fields and store large amount of dataa town. Every screen The register book (record~210 KB) is stored automatically saved in the disk with a different name(disk 0) and is loaded once in the RAM of the CPC6128. Then, so that it using On File Database, a full-screen record can be accessed by other programs, like word processorscreated for each citizen. In order to set up a new database: 1) Start a new file system by resetting The records of the database and the master record. 2) Frame and/are saved in 26 different disks (disks A-Z or draw HD20), depending on the master recordsurname of each resident. 3) Edit Notice, that the fields and register book remains in RAM until the structure end of the master record. 4work regardless of which disk (A-Z/HD20) Append is used. Upon exit, the records 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, a 800 KB external floppy drive, the database on the basis specific version of the master recordCP/M plus (v1.1x), RamDOS D20 disks or HD20.

Relations: 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 (not the ^ symbol) followed by one space, for example Z80 . If a record contains more than one relational key, the key at the lowest field is set as the active key. In case of large databases move the parent records at the start of the database list. Notes: and On File capacity is 200 records (equal to 400 KB2025)respectively. The original disk contains some demo master records (*.002 files) as well as the boot sectors for CP/M 2.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]]