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]] , '''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 celebrate access the anniversaries of CPC (40 years!) and RAM-disk contents upon restart. The original disk contains CP/M-80 plus boot sectors (50 years!Dobbertin v1.1x), a database of old computers and a register book for the period 1970-1989. On File database (2024/2025) is disk-based, thus all the records are stored in the disk drive as stand-alone files. On the other hand, On File Register uses a business application similar single file to store the MSDOSrecords in the RAM-era PC applications 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 one forth while reading the records. Notice, that in the 2025 version, in order to maximize the free directory entries and to overcome the Compiler and Editor Overflow, a big part of the most recent On File source code (2024ONFILE.COM) projects developed for CP/Mhas been '''encapsulated in the source code''' of the Register Book (REGISTER.COM) and is accessed upon user request via boolean expressions that are temporarily stored in the RAM-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 a single record; thus there is plenty of space come to edit many different fields and store large amount of datafill? Let’s give an example. Setting up a new database using Using On File is very easy: 1) start the new file system by resetting the database and the master recordRegister, 2) frame and/or draw the master recorda register book can be set up with, 3for example, 5000 citizens of a town. The register book (~210 KB) is saved in disk (disk 0) edit the fields and is loaded once in the structure RAM of the master recordCPC6128. Then, 4) append the records in the database on the basis of the master using On File Database, a full-screen record. The database can be either flat or relationalcreated for each citizen. Children The records include of the ^ symbol followed by the relational key and one space, for example ^Z80 . The relational key can contain up to 15 symbols database are saved in 26 different disks (disks A..-Zor HD20), a.depending on the surname of each resident.zNotice, 1..0,+,?, etc.). Parent records include that the relational key (not register book remains in RAM until the ^ symbolend of the work regardless of which disk (A-Z/HD20) followed by one space, for example Z80 is used. If a record contains more than one relational key Upon exit, the key at contents of the lowest field is set as the active key. Every record has its own unique filenameRAM (register book, stored if modified) are saved in the 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 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. <br>

As per [[Cosmos]], Using the following two links you can download On File has been developed on the basis of the hardware peripherals as well as the software that were FIle (contemporary2024) available for the CP/M and the CPC6128: the 512 KB [[Dobbertin Memory Expansion]], the [[ParaDOS]] or [[X-DDOS]] ROMS for the external (800 KB) floppy drive, the 20 MB [[Dobbertin Harddisc]], the [[Amstrad Serial Interface]], the Amstrad Parallel [[Printer Port]], the [[CTM640/CTM644]] colour monitor, the [[AMX Mouse]], the [[MicroScript]] (142 KB), the [[WordStar]] (706 KB), the [[Protext]] (406 KB), the [[Multiplan]] (208 KB), the [[SuperCalc 2]] (240 KB), the [[dBase II]] (272 KB), the [[DR Draw]] (235 KB), the [[DR Graph]] (306 KB), the [[MAXAM]] (206 KB), the [[Atlast Plus]] (224 KB) and other [[Programming software]]. On File includes a graphics screen saver, is based on the [[Dobbertin]] version of CP/M 2.2 (v1.22025) which provides 59 KB TPA, supports the RAM expansion and the 20 MB hard diskrespectively. 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]]