Changes

[[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/M2.2'''. As per [[Cosmos]], On File has been developed on the basis of all 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. On File database 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. Setting up a new database using On File database is very easy and can be performed in three steps: 1) start the new file system by resetting the database and 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. 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. Children records include the ^ symbol followed by the relational key and one space, for example ^Z80 . Parent records include the relational key On File (not the ^ symbol2024) followed by one space, for example Z80 . On File database has maximum capacity of 200 records (400 KB). The original disk contains some the boot sectors for CP/M 2.2 (Dobbertin v1.2 for 128 KB RAM), a few demo master records (*.002 files), some demo records a few database examples, the application (*.REC filesCOM file) , as well as the boot sectors for CP/M 2.2 color screen saver (v1.2CHN file).

In summer '''On File (2025)''' a new Database Management System for '''CP/M plus''' was released in June 2025. In addition to the 2024 version of On File , it includes the options to Group and to Invert the records, to Index the database will be released, which will include to perform Index based search and to perform field based calculations. It 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 will provide provides capacity for a few thousands of single-field records. Hence, On File 2025 requires RAM expansion to run and includes a resume option in order to access the user can set up eRAM-disk contents upon restart.gThe original disk contains CP/M plus boot sectors (Dobbertin v1. 1x), a Register database of Earthquakes (date, time, location, magnitude, depth, duration) using old computers and a register book for the period 1970-1989. On File Registerdatabase (2024/2025) is disk-based, while keeping detailed thus all the records of specific earthquakes (eare stored in the disk drive as stand-alone files.g. > 6 R) using On File Database. As per [[Cosmos]]the other hand, On File Register has uses a resume option in order single file to access store the records in the RAM-disk contents anytime and it also includes . For large register books which contain more than 64 records, a color graphic screen saver16 KB "cache" memory is implemented in order to be able to move back and forth while reading the records. FurthermoreNotice, that in the 2025 version will also support Grouping , in order to maximize the free directory entries and Inversion to overcome the Compiler and Editor Overflow, a big part of recordsthe On File source code (ONFILE.COM) has 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.

What gap of the 80's does On File database is disk-based, thus all the records are stored in the disk drive as stand-alone files(2025) come to fill? Let’s give a “professional” example. On the other hand, Using On File Register uses , a register book of earthquakes that are realized in a single file to store the recordsspecific country can be set up, which is loaded in RAM-disk from the disk driveincluding Serial Number, Date, Time, Location, Duration, Depth and Magnitude. The maximum capacity of Then using On File database depends on the maximum directory entries (64/128/256/512 etc.)Database, whereas the maximum capacity detailed records of the On File Register depends on the size of the RAM-disk and/or the disk driveearthquakes that where stronger than e. [[ROMDOS]] 800 KB disks which g. 5 Richter can store be set up to 256 files are ideal to run On File databaseincluding the map of their location. The 20 MB [[Dobbertin Harddisc]] or similar media which support more directory entries This can also be used. On File database access the records directly by reading the related files from the disk, while On File Register access the records serially from the achieved with an Amstrad CPC6128 with 512 KB RAM-disk. For large register books which contain more than 64 recordsexpansion, a 16 800 KB "cache" memory is implemented in order to be able to move back and forth while reading external floppy drive, the recordsspecific version of CP/M plus (v1. Notice1x), that RamDOS D20 disks or HD20. Using the amount of data that following two links you can be stored download On FIle (2024) and accessed using On File Database/Register resembles to the 16-bit world of computing ([[Other Computers:16 bit computers]]2025)respectively.