Home » Categories » Solutions by Business Process » Profiler |
Screen Actions - Master/Detail Revision Counter |
Article Number: 2125 | Rating: Unrated | Last Updated: Mon, Jun 19, 2023 at 10:52 PM
|
Datafile Software Solutions Screen Actions - Master/Detail Revision Counter This facility allows for the maintenance of a ‘Revision No’ on the master record within a ProFiler application. This ‘Revision No’ is an incremental counter that increases on each change of the master record or the linked detail records. ![]() On save of the master record on initial add or if, as here, exit of the details after initial add of a master record the system will prompt ‘Is the Initial Setup Complete’. If you respond ‘Yes’ then the revision counter is set as ‘1’ and each subsequent amendment – update of master record or change to detail records – increments the counter by 1. If you respond ‘No’ then the revision counter is left as ‘0’, and after each subsequent update to the master record or changes to the detail records the system will again ask if the initial setup is complete. Once you have responded that the initial set-up is complete there is no further user interaction required to control the increment of the revision number. Note that if change multiple details in one session this only counts as one change to the revision number. InstallationDatabase ChangesA new item is required on the master database of the ProFiler application to maintain a revision number counter. To restructure the database select Database Systems from the main menu followed by ProFiler Application Definition, Database Utilities and then Restructure A Database. If prompted with the list of applications (first time in) select the application required before entering the pathname for the master database required and press <Enter>. The existing data items are then displayed on screen, scroll-down to the next available blank entries and create the following items: Item Type Description REVISION NO N Incremental Counter for Revision Number. To insert a new item press <Enter> against a blank entry, enter the title as required and press <Enter>, select the item type (using the drop-down list if required), and depending on item type select the size required. Once the additional items have been recorded press the <ESC> key and select the UPDATE button to save the database changes. When prompted respond ‘Y’ to the prompts to ‘Extract Existing Data to New Database Structure’ and, if appropriate, ‘Copy Table Entries from Old Database to New Database’. A final prompts ask to ‘Remove (.OLD) Database’ – respond as required. Data File Profiles / File LinksThe new master item needs to be referenced within the Data File Profiles for the ProFiler application.To update the profiles select Database Systems from the main menu followed by ProFiler Application Definition and then Data File Profiles. If prompted with the list of applications (first time in) select the required application before selecting the master file (file 1) of the application. Press <Enter> through the initial parameters for the master file and it’s linked files until the profiles for the Master/Detail relationship are displayed. ![]() A new option has been added into the main file items – Revision No. Reference the newly added data item and <Enter> through the remaining items.Note that if you have more than one detail file within the application the Revision No counter item is shared across all detail databases. |
Attachments
![]() There are no attachments for this article.
|
Select Current Application
Viewed 1536 times since Thu, Jun 28, 2012
Application Files – User-Id Filenames
Viewed 756 times since Thu, Jun 18, 2020
User-Defined Reports - Output to CSV
Viewed 1332 times since Wed, Jun 13, 2012
Generate Stock Transactions (9909)
Viewed 1357 times since Fri, Jun 29, 2012
Pre-Define Forms
Viewed 1370 times since Thu, Jun 28, 2012
Perform Direct a Database Function
Viewed 1320 times since Fri, Jun 29, 2012
General Lookup File - EDI Order Processing
Viewed 1520 times since Thu, Jul 5, 2012
W - W.P. Facility
Viewed 1268 times since Fri, Jun 29, 2012
Print Menu Structure
Viewed 1391 times since Thu, Jun 28, 2012
User-Defined Reports - Print Images
Viewed 1517 times since Mon, Jun 11, 2012
|