Changes

'''[[Image:On_File_Main_Menu.jpg|right|thumb|250px|On File''' Database Management System was released in June 2024 by main menu]][[KSLImage:On_File_typical_record.jpg|right|thumb|250px|On File fuel consumption record]] in order to celebrate the anniversaries of CPC (40 years!) and CP/M-80 (50 years!).<br>[[Image:On_File_Car_Maintenance_Record.jpg|right|thumb|250px|On File car maintenance record]]

'''On File''' 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 (2024) projects developed for CP/M. On File database is disk-based, quick and reliable. It uses the entire CPC screen as the platform for the records; thus there is plenty of space to store large amount of data. In addition, a wide variety of characters and symbols can be included in the records, hence the database can contain data beyond the typical and traditional text type. Setting up a new databaseusing On File is very easy and can be performed in three steps: 1) Start a start the new file system by resetting the database and the master record. , 2) Frame andframe/or draw the master record. Edit the fields and edit the structure of the master record. , 3) Append the append new records in the database on . The database is fully dynamic, thus the basis of user can modify the master recordas 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 (not the ^ symbol) followed by one space, for example Z80 . Every record has its own unique filename, stored in the disk drive. On File capacity is 200 records (equal to 400 KB), it 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 the RAM Disk.<br>

Relations: The database can be either flat or relational. Children records include As per [[Cosmos]], On File has been developed on the ^ symbol followed by basis of the relational key hardware peripherals as well as the software that were (contemporary) available for the CP/M and one spacethe CPC6128: the 512 KB [[Dobbertin Memory Expansion]], the [[ParaDOS]] or [[X-DDOS]] ROMS for example ^Z80 . The relational key can contain up to 15 symbols the external (A..Z800 KB) floppy drive, a..zthe 20 MB [[Dobbertin Harddisc]], 1..0the [[Amstrad Serial Interface]],+the Amstrad Parallel [[Printer Port]],?the [[CTM640/CTM644]] colour monitor, etc.the [[AMX Mouse]], the [[MicroScript]] (142 KB). Parent records include , the relational key [[WordStar]] (not 706 KB), the ^ symbol[[Protext]] (406 KB) followed by one space, for example Z80 . If a record contains more than one relational keythe [[Multiplan]] (208 KB), the key at [[SuperCalc 2]] (240 KB), the lowest field is set as [[dBase II]] (272 KB), the active key. In case of large databases move [[DR Draw]] (235 KB), the parent records at [[DR Graph]] (306 KB), the start of [[MAXAM]] (206 KB), the database list[[Atlast Plus]] (224 KB) and other [[Programming software]]. Notes: On File capacity includes a graphics screen saver, is 200 records based on the [[Dobbertin]] version of CP/M 2.2 (equal to 400 KBv1.2)which provides 59 KB TPA, supports the RAM expansion and the 20 MB hard disk. The original disk contains some demo master records (*.002 files) , some demo records as well as the boot sectors for CP/M 2.2 (v1.2)

[[Category:Applications]] [[Category:CP/M]]