Changes

Jump to: navigation, search

On File

247 bytes removed, 16:34, 15 August 2025
'''On File (2025)''' Database Management System for '''CP/M plus''' was released in June 2025. In addition to the 2024 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 [[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 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 access the RAM-disk contents upon restart. The original disk contains CP/M plus 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, thus all the records are stored in the disk drive as stand-alone files. On the other hand, On File Register uses a single file to store the records in the RAM-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 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 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.

Deprecated: The each() function is deprecated. This message will be suppressed on further calls in /mnt/cpcwiki-httpdocs/includes/diff/DairikiDiff.php on line 434
What gap of the 80's does On File (2025) come to fill? Let’s give an a “professional” example. Using On File Register, a register book of earthquakes that are realized in a specific country can be set up with, for exampleincluding Serial Number, Date, Time, 5000 citizens of a town. The register book (~210 KB) is saved in disk (disk 0) Location, Duration, Depth and is loaded once in the RAM of the CPC6128Magnitude. Then, using On File Database, a full-screen record can be created for each citizen. The detailed records of the database are saved in 26 different disks (disks A-Z or HD20), depending on the surname of each residentearthquakes that where stronger than e. Notice, that g. 5 Richter can be set up including the register book remains in RAM until the end map of the work regardless of which disk (A-Z/HD20) is usedtheir location. Upon exit, the 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 plus (v1.1x), RamDOS D20 disks or HD20.
Using the following two links you can download On FIle (2024) and On File (2025) respectively.
KSL
443
edits
Retrieved from "https://oldwiki.cpcwiki.eu/index.php/Special:MobileDiff/126809"