The View Data Dialog

 

 

All result sets in db-JAPI are generated by TLptsRowSetFactory. The View Data Dialog is a listener of the events of the factory and as such can show the results of the static and dynamic result sets.

Below we see a set of dynamic results, which are generated from three statements that are related. The client statement is at the top level with the account statement related dynamically to it. The trans statement is related to the account statement in the same way.


Number (1) shows the tree structure created by the relationship between the three statements used. This tree gives us the ability to select one or more result sets by using the mouse and CNTRL or SHIFT. Furthermore, we can select all the result sets from a certain level, by first specifying the level (3) and then selecting all the items in the tree.
Number (2) shows us the colour coding, as shown in the levels (3) selection. There is also an offset so that relationships can be recognised easily.
Each of the result sets has the name of the statement in the title bar and also provides the ability to show up to the first 1000 records of that result set. When the result set opens, the first 10 records are shown and the user can select from the drop list or enter a value in the field next to it if exact numbers are required. The arrows for forward and reverse allow for moving within the data set of up to 1000 records.

Each result set box has its own selection menu, as shown on the left, for filtering the header and tools, and for selecting the encoding. These selections are provide immediate feedback on the action required as we select them.


In the image above we see the same output, but with the difference that the columns and tools have been filtered. As with the selection options per result set box, we have the ability to set the columns filter and charset for all result set from the area pointed to by (3)