HomeAppeon Web | Appeon Mobile | Appeon PowerBuilderAppeon Online Help Center

DataWindow presentation styles

Composite DataWindow
CrossTab DataWindow
Grouping in DataWindow
Graph DataWindow
RichText DataWindow
TreeView DataWindow

Table 250. 

CrossTab, Composite, Freeform, Graph, Grid, Group, Label, N-Up, Tabular, TreeView and RichText presentation styles

Supported

DataWindow objects and controls in a DataWindow can be dynamically created (e.g. by using the CREATE statement).

CrossTab, Composite, Freeform, Graph, Grid, Group, Label, N-Up, Tabular, TreeView and RichText style DataWindows are implemented in XML in Appeon deployed applications.

Shortcut keys “Ctrl + Home” and “Ctrl + End” are supported in Grid, Freeform, Tabular and N-up DataWindows. The Web UI and behavior are identical with the original PowerBuilder DataWindows, except for a few differences listed below.

Decimal retrieval argument is supported.

Differences

For all supported DataWindows, it ignores the upper or lower case when sorting by the column names.

For CrossTab style:

If the CrossTab DataWindow object contains over 3 headers, make sure the columns are sorted in the same order in both the DataWindow object and the SQL scripts, otherwise the value displayed in the detail field will be incorrect.

Refer to the detailed description of differences CrossTab DataWindow.

For Composite style:

Refer to the detailed description of differences Composite DataWindow.

For Freeform style:

When a user adjusts a scrollbar up and down, before the user releases the scrollbar, the DataWindow's contents are scrolled up and down in correspondence with the scrollbar's position. This does not happen in PowerBuilder applications.

For Grid style:

  1. Web application supports dragging and dropping columns in different locations on a Grid DataWindow. You can select a column header and drag it over other columns and drop the column in any location within the DataWindow. The selected column will be highlighted.

  2. Sorting a column or selecting all the items by clicking the column header is unsupported.

  3. In PowerBuilder, the tab sequence in a Grid DataWindow object is always left to right (except for right-to-left operating systems). Changing the tab value to any number other than 0 has no effect. In the Web Grid DataWindow, changing the tab value to any number other than 0 does have an effect. If the user presses Tab, the focus will change according to the predefined tab order.

  4. The color of the DataWindow border will be changed as the background color changes in the PowerBuilder application. This is not so in the Web application.

  5. If "Suppress Repeating Values" is selected for rows, there will be noticeable short breaks in the grid lines.

For Group style:

Refer to the detailed description of differences Grouping in DataWindow.

For Graph style:

Refer to the detailed description of differences Graph DataWindow.

For Label style:

RowFocusChange event is unsupported.

For N-Up style:

When dynamically changing the height of DataWindow, the number of pages is recalculated on the Web but it is not recalculated in PowerBuilder.

For TreeView style:

Refer to the detailed description of differences TreeView DataWindow.

For RichText style:

Refer to the detailed description of differences RichText DataWindow.

For more DataWindow user operation differences, refer to DataWindow enhancements and differences.

Other DataWindow presentation styles

Unsupported

OLE DataWindow

Prev  Up  Next
Using SQL statements in DataWindows  Home  Composite DataWindow