Going Forward. Over the years, that is from 1996 through the present, Whitemarsh Information Systems has installed in excess of 100 instances of UltraTree’s in its main business application, the Metabase System. It is an Enteprise Management System that enables the top several layers of an enterprise to become fully integrated, non-redundant, interoperable, and mapped to an Enterprise's level of operational systems such as Finance, HR, manufacturing, Sales, Marketing and distribution.

During these many years of these implementations, Whitemarsh has created over 75 different files containing code extensions, step-by-step guides, and whole specialized UltraTree based applications that can be employed by virtually all Clarion developers. It is because of Whitemarsh’s intense use of UltraTree in its for-sale Clarion-based applications that many use-based assists were identified and created.

One Procedure Routine extension protects against row deletion that might result in UltraTree branch orphans.

Another set of Procedure Routines reorganizes the sequence of rows contained in an UltraTree display subsequent to a user’s decision to remove one or more rows.

Another Procedure Routine enables the reassignment of UltraTree rows from one tree to another.

Another Procedure Routine detects infinite recursions, and flags where it starts and then stops the infinite unfolding of UltraTree’s display

Developed also has been a standalone example-use of an UltraTree application that clearly presents an understanding just what rows actually exist within a Single Table Hierarchy's single physical file versus a multiply-reused set of rows contained in a Multi Table Network file set. This knowledge is critical to a real understanding of Bill of Materials (BOM), which is a more common name than MultiTableNetwork. It's referred to hereafter as UltraTree(BOM).
Developed also are Clarion Procedure Routines for “walking” up and down decedents and ascendents for both SingleTableHierarchy and UltraTree(BOM) structures.

Developed too are routines for printing UltraTree in their display order versus printouts in table- stored-row order.
 
Tangential but related, subsequent to the death of “JP” who had created a database migration system, Whitemarsh undertook a near three-year effort to create a greatly expanded replacement Database Migration System. This system not only migrates data models but also the data rows. It had to be specially written to accommodate the needs of UltraTrees.

Another recently developed UltraTree Clarion-based application displays data models from DCTX files as well as creating the SQL Data Definition Language scripts from that DCTX.

Another set of generally reusable set of Clarion Procedure Routines created over a six-month effort enables the processing of display-based rows of an UltraTree versus the physical file set of rows. This is not a distinction without a difference. Rather the difference is critical.

This enables what would is a traditional application processing of the display tree. Critical in this effort was the automatic determination of both undefined tree depth and width. These Procedure Routines are able to be included where needed in different Clarion applications via table and column name mapping thus eliminating the need for any actual code rewriting.

Copyright 2024, Whitemarsh Information Systems Corporation
All Rights Reserved