Changes

On File

1,394 bytes added, 15 August
[[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) database has maximum capacity of 200 records (400 KB). The original disk contains the boot sectors for CP/M 2.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).
'''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. 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 stand-alone files. On the platform for the records; thus there is plenty of space to store large amount of data. In additionother hand, On File Register uses a wide variety of characters and symbols can be included single file to store the records in the RAM-disk. For large register books which contain more than 64 records, hence the database can contain data beyond the typical and traditional text type. Setting up 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. The database is fully dynamicNotice, thus the user can modify that in 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 the ^ symbol followed by free directory entries and to overcome 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 records (equal to 400 KBCOM), it and is thus an ideal application for the 20 MB [[Dobbertin Harddisc]] which supports up to 512 file entries as well as [[ROMDOS]] or [[ParaDOS]] disks (128 x 2). Furthermore, On File can be also executed entirely from accessed upon user request via boolean expressions that are temporarily stored in the RAM Disk-disk. <br>
As per [[Cosmos]], On File has been developed on the basis What gap of the hardware peripherals as well as the software that were 80's does On File (contemporary2025) available for the CP/M and the CPC6128: the 512 KB [[Dobbertin Memory Expansion]]come to fill? Let’s give a “professional” example. Using On File Register, the [[ParaDOS]] or [[X-DDOS]] ROMS for the external (800 KB) floppy drivea register book of earthquakes that are realized in a specific country can be set up, the 20 MB [[Dobbertin Harddisc]], the [[Amstrad including Serial Interface]]Number, the Amstrad Parallel [[Printer Port]]Date, the [[CTM640/CTM644]] colour monitorTime, the [[AMX Mouse]]Location, the [[MicroScript]] (142 KB)Duration, the [[WordStar]] (706 KB)Depth and Magnitude. Then using On File Database, detailed records of the [[Protext]] (406 KB), earthquakes that where stronger than e.g. 5 Richter can be set up including the [[Multiplan]] (208 map of their location. This can be achieved with an Amstrad CPC6128 with 512 KB)RAM expansion, the [[SuperCalc 2]] (240 a 800 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 saverexternal floppy drive, is based on the [[Dobbertin]] specific version of CP/M 2.2 plus (v1.21x) which provides 59 KB TPA, supports RamDOS D20 disks or HD20. Using the RAM expansion following two links you can download On FIle (2024) and the 20 MB hard disk. The original disk contains some demo master records On File (*.002 files2025), some demo records as well as the boot sectors for CP/M 2respectively.2 (v1.2)
== Download ==
* [http://www.cpcwiki.eu/index.php/File:On_File_2024_Boot_Disk.dsk Download from CPCWiki]
 
[[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]]
430
edits