Home » Categories » Solutions by Business Process » System Features

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 adds the facility to default to a set search item. From Release 6.5 the Desktop Database options ‘Databases on Desktop’, ‘Forms on Desktop’ and the (Premier only) ‘Database Plus on Desktop’ configuration options have been updated to include both of these facilities.

Installation

Desktop Database Configuration

The <F4-Select> display for the Desktop Database options are configured through the Desktop Tool options. To update the tools select Database Systems from the main menu followed by Datafiler Database Utilities and then Desktop Tools Definition. Select the required list option from the menus Databases on Desktop Definition,Forms on Desktop Definition and Database Plus Definition before selecting the option database definition from the list. Confirm any authority settings for the database before selecting the UPDATE button and select the Screen Action / Options parameter screen. The new F4-Select configuration options are available on the second screen of parameters.


Auto-Sort Column – select which of the data items above the search results within <F4> are to be sorted in. The column number corresponds to the entry numbers 1-10.Setting this option overrides the LIFO sequence parameter available on this screen.

Auto-Sort Descending– if a sort item is set then setting this parameter processes the sort in descending rather than ascending order.

F4-Focus – when you press F4-Select you can search based on the prime-index of the database, any set secondary indexes and (if Premier) any set extra selection items. Set the focus item to ‘1’ to default the search to the prime-index, to ‘2’ or ‘3’ for any set secondary indexes, and ‘4’ through to ‘9’ for any of the extra selection items. Pressing the <F7-Option> key on this item allows you to view the set secondary indexes and extra selection items for the current database.

Custom Fields
  • Release ID: 6.5
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Selection Criteria Range ‘Value’ Input
Viewed 1652 times since Fri, May 27, 2016
Ledger Enquiries – Application Web Links
Viewed 536 times since Wed, Jun 17, 2020
Additional F4-Select Options
Viewed 2861 times since Wed, Jun 13, 2012
Compress Address Lines and Post Code
Viewed 2660 times since Wed, Jun 13, 2012
Application Pick Lists - Apply Colour Highlighting Rules
Viewed 1523 times since Wed, Sep 21, 2016
Filter Records on Enquiry Search
Viewed 4744 times since Fri, Oct 26, 2012
Scanned Documents - Save As PDF
Viewed 2183 times since Mon, Jun 11, 2012
Default Printer / Tray Settings
Viewed 1867 times since Wed, Jun 13, 2012
Log User-Id / Date / Time Database Record Updated
Viewed 3063 times since Fri, Oct 26, 2012
T-Table Description as Data Item
Viewed 1729 times since Wed, Jun 13, 2012