What Is It
DataTreeGen - creates and edits TCB data tree diagrams. The user can insert graphics from embedded TCB or from file using drop-down lists. It is used with TCB TreeView Master program to display documents of just about any kind from graphical, hierarchical tree style lists. .
DataTreeGen data tree charts can be loaded from a file dialogue or selected from a diagram database. See Data Tree Chart Files below.
The majority of the screen consists of a large text box that will contain the body of a diagram file. At the far left of the process window is a vertical line of four buttons. The first or help button should display this document. The next, green, button minimizes the screen to the system tray. The third, or blue button toggles the Word Master window to stay on top of other windows or not. The last, red button exits DataTreeGen.
In the top middle of the window to the right of the "Data Tree" label is a drop-down selection box labeled, "Embedded Images". Selecting an item from the drop-down and pressing the Enter key, inserts the selected graphic name in the data tree box.
This is the work/composition window. Its primary function is to provide the ability to edit and then run DataTreeGen chart files. The first or left most button above the composition screen opens a dialogue that lets the user select any file from disk to load into the composition window. The next button opens a dialogue that lets the user select a file name and location to save the contents of the composition window.
The third button takes the contents of the composition window and executes each line as though it where a command line in a "batch" file. Command lines may consist of compound combinations, separated by a "|" character, of any mix of TCB functions or Windows or DOS commands. Multiple line SQL queries on these command lines are accommodated by the convention of using the "\n " three character combination instead of a linefeed in the query. The fourth button takes the contents of the composition window and passes the information to the TCB SQL query processor for execution. The query can consist of standard SQl statements as well as SQLite "." commands. Query results can be "spooled" to the composition window.
You can set any SQLite database file to the default expected in most queries by using the TCB function db3file= before composing and running a query. It has the form: db3file=[database path\file]. So, executing the command line db3file=data\mydata.db3|seltable=mytable| will set data\mydata.db3 as the default database file and the table in it, mytable as the default table. Documentation for TCB functions and processes is found in the docs\ folder where this document should reside.
The last button clears the composition window. The data tree and composition window combination provides a very powerful data exploration interface. If the button above the right corner of the composition window is pressed. the window morphs back to the data tree view.
Data Tree Chart Files
The data tree chart files are contained in plain text files and have a fairly simple format. The data tree processor expects a file with two type of objects, graphic objects and data objects, in any order but it is wise to group object together. The graphics objects consist of a single line of text in the following format:
The data objects or chart elements consist of a single line of text with five parameters in the following format:
We are concerned with a major concept in tree structures, parents and children. Its pretty simple, a parent can have children and a parent. Children can be parents but have only one parent. Secondarily, each element must have a valid graphic assigned to it or it effectively doesn't exist.
Each table that is loaded may share graphics but all element tags must be unique from elements in other charts already loaded or the element won't display. Treemaster primary method of working is being able to execute a command line from an element. The command line replaces the name tag in an element.
graf=[graphic tag],[graphic file spec]
Examples:
graf=report,grafics\report.ico
graf=table,grafics\table.ico
The graf= is required. The graphic tag is referenced in the data objects as the graphic to use for that tree element. The graphic file spec is the location of the graphic file on disk. If a graphic object doesn't exist for an element, the element won't show.
node=[parent tag],[tvwChild],[element tag],[text],[graphic tag]
Example Root Element:
node=,,Lev11,TreeDocs,report
Example Child Element:
node=Lev11,tvwChild,Lev21,DataTreeGen Documentation,table
The node= is required. The parent tag is only used in an element if it is the child of an element, a child of parent tag. The tvwChild is a constant that is required if the chart element has a parent. The element tag is the name of a particular chart element. The text parameter is the element text that appears in the display. The graphic tag parameter references a graphic object in the file from the graf= objects.
Copyright © 1982-2016 Phoenix Information Systems/TM all rights reserved
Contact: Fred Pierce, makpiya@aol.com, makpiya@gmail.com, 831.240.9969