Dataset Viewer

Attached (below) is the first version (written in OpenEdge 10.1a) of the Dataset. This program can show the contents of any dataset, including the records in the before table if present. Here is a screenshot of the dataset viewer:Explanation:

  • in the window title you can see the name of the dataset
  • every temp-table in the dataset gets its own tab with its name on it (ttOrder, ttOrderLine)
  • selecting a table-tab will highlight the tab and select a page (this is no more than a frame which is moved to top)
  • On the picture above there are 2 browses. The top one is for the after table; the bottom one for the before table. If no before table is present, the (after) browse will fill the entire page. (see picture below)
  • The possible row-states are on the left bottom of the interface. Every row-state has its own color, which is also reflected in the browse rows. (The colors are set and selected at runtime, so no registry settings/ini files need to be adjusted. By the way: if you don't like the colors; you can edit them in the function setColors).
  • If you select a record in the before- or after-browse, the corresponding record from the after- or before-browse is selected. If no corresponding record exists in the target-browse, the currently selected record in the target-browse is deselected.
  • Selecting a record in any browse will show a bullet next to the row-state, signifying the row-state of the currently selected record.

Here is another screenshot for a table without a before-table:Here you can also see, that if a particular row-state is not available, it will be greyed out. I think this tool can help to display the contents of before and after tables.