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(2025)''' Database Management System for '''CP/M plus''' was released in June 2025. In addition to the 2024 by 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 [[KSLGSX]] in order to celebrate the anniversaries , '''field-based graphics''', unlimited number of CPC (40 years!) Relational Keys and CP/MOn Board help. It also includes '''On File Register''', a RAM-80 (50 years!)disk based register book. The latter provides capacity for a few thousands of single-field records. On File is 2025 requires RAM expansion to run and includes a business application similar resume option in order to access the MSDOSRAM-era PC applications and one of the most recent (2024) projects developed for disk contents upon restart. The original disk contains CP/Mplus boot sectors (Dobbertin v1.1x), a database of old computers and a register book for the period 1970-1989. <br> <br> On File database (2024/2025) is disk-based, quick and reliable. It uses thus all the entire CPC screen records are stored in the disk drive as the platform for the records; thus there is plenty of space to store large amount of datastand-alone files. In additionOn the other hand, On File Register uses a wide variety of characters and symbols can be included in single file to store the records, hence in the database can contain data beyond the typical and traditional text typeRAM-disk. Setting up For large register books which contain more than 64 records, a new database using On File 16 KB "cache" memory is very easy and can be performed implemented in three steps: 1) start the new file system by resetting the database order to be able to move back and forth while reading the master record, 2) frame/draw and edit the structure of the master record, 3) append new records in the database on the basis of the master record. The database is fully dynamicNotice, thus that in the user can modify the master record as well as any record anytime. Furthermore2025 version, in order to maximize the database can be either flat or relational. Children records include free directory entries and to overcome the ^ symbol followed by the relational key Compiler and one spaceEditor Overflow, for example ^Z80 . Parent records include a big part of the relational key On File source code (not the ^ symbolONFILE.COM) followed by one space, for example Z80 . Every record has its own unique filename, stored been '''encapsulated in the disk drivesource code''' of the Register Book (REGISTER. On File capacity is 200 screen records (equal to 400 KBCOM), it and is thus an ideal application for accessed upon user request via boolean expressions that are temporarily stored in the 20 MB [[Dobbertin Harddisc]] which supports up to 512 file entries as well as [[ROMDOS]] or [[ParaDOS]] 80 track disksRAM-disk. <br>

As per [[Cosmos]], On File has been developed on the basis What gap of all the hardware peripherals as well as the software that were 80's does On File (contemporary2025) available come to fill? Let’s give an example. Using On File Register, a register book can be set up with, for the CP/M example, 5000 citizens of a town. The register book (~210 KB) is saved in disk (disk 0) and is loaded once in the RAM of the CPC6128. Then, using On File Database, a full-screen record can be created for each citizen. The original disk contains some demo master records of the database are saved in 26 different disks (*disks A-Z or HD20), depending on the surname of each resident.002 filesNotice, that the register book remains in RAM until the end of the work regardless of which disk (A-Z/HD20)is used. Upon exit, some demo records as well as the boot sectors for 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 specific version of CP/M 2.2 plus (v1.21x), RamDOS D20 disks or HD20.

<br><br> '''Using the following two links you can download On File Register Book''' FIle (On File extender2024) which runs using entirely the RAM expansion will be released in summer 2025. In contrast with On File, where the records are Disk-based stand-alone files, On File Register Book is RAM-based and single filed, thus it provides practically endless capacity. The user can set up a Register of e.g. 2500 Members while keeping 200 detailed records of them using On File(2025) respectively.