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
Ledger Enquiry - Additional History Enquiry Databases
Viewed 272 times since Tue, Oct 15, 2024
Allow Four Application Enquiry Screens
Viewed 1684 times since Fri, May 20, 2016
Landing Grids
Viewed 1714 times since Mon, Jun 26, 2017
Update Job Record within Enquiry
Viewed 2114 times since Tue, Jun 12, 2012
General System Options - Set ‘From’ Email Account
Viewed 162 times since Thu, Oct 17, 2024
Application Reports - Save PDF Copy to Folder
Viewed 1980 times since Mon, Nov 25, 2013
SMB2, SMB3 and Opportunistic Locking
Viewed 25088 times since Tue, Apr 8, 2014
Automatically Display Linked Files - Allow Items from Lookup Database in History/Details List - Link to BOM Detail Pick List
Viewed 2060 times since Fri, Jul 21, 2017
Documents to Email - Merge PDF Attachments
Viewed 2363 times since Mon, Jun 11, 2012
Screen Design - Allow 64 Data Items per Screen Layout
Viewed 2878 times since Mon, Jun 11, 2012