1. Desktop Database Tools - Additional F4-Select Options Datafile Software Desktop Database Tools - Additional F4-Select Options Earlier releases introduced the facility to sort by default the records displayed from an <F4-Select> search based on one of the columns displayed, whilst this release ad... Read More
2. Database Refresh - Empty Table and Re-Import Data Datafile Software Database Refresh - Empty Table and Re-Import Data Release 6.4 introduces several additional processing options for mirroring a Datafile Database to an SQL table when the SQL Driver has been purchased.  Against each Datafile... Read More
3. SQLDET Database Structure Datafile Software SQLDET Database Structure Two new data items can be added to the SQLDET.DFD file that will record the program and the parameter number which generated, together with the existing (Premier only) options to record the user-id, da... Read More
4. Print Database Structure Datafile Software Print Database Structure During system maintenance it can be useful tool to print the database structure which details the data item names and types within the system. Where Table Items and Constant Values (both as an item type... Read More
5. History Database Cross-Links Datafile Software History Database Cross-Links The Datafile Premier system allows extra detail databases, termed ‘History’ files, to be viewed off the Sales Ledger, Purchase Ledger, Sales Order and Purchase Order Ledger Enquiry optio... Read More
6. Database Activity Alerts Datafile Software Database Activity Alerts This new accessory, available as a trial in Release 6.2, allows the system to create/send emails when, for example, an account is placed on stop or goes over its credit limit. The Alerts option also all... Read More
7. Extra 160 Items per Database Datafile Software Extra 160 Items per Database From Release 5.9 each database in the system will allow up to 320 data items – doubling the existing availability of 160. No specific changes are required to enable these items other than the stan... Read More
8. Report with Output Database Updating – Wait Record Locking for Update Database Datafile Software Report with Output Database Updating – Wait Record Locking for Update Database The option ‘Report with Output Database Updating’, more commonly referred to as the ‘Sort & Slot Report’ exclusively l... Read More
9. Database Audit - Stock Control Datafile Software Database Audit - Stock Control Use this option to check the internal integrity of any of the Stock application files. If you’re sure that a particular record is in the file but you cannot select it via the indexes then yo... Read More
10. Compact & Audit Database - Stock Control Datafile Software Compact & Audit Database - Stock Control The internal processing of databases does not necessarily re-use the space occupied by records that have been deleted (particularly in master files such as the Stock file). New recor... Read More