Designing DataWindow objects for the Web DataWindow
The Web DataWindow supports most PowerBuilder DataWindow functionality.
This section describes what features to use to take full advantage of
the Web DataWindow.

The properties of DataWindow column edit styles default to
values that optimize their appearance—for example, radio
buttons are left aligned. If you must change these style properties,
the appearance of a column in the Web DataWindow might differ from
its appearance in the DataWindow painter because the browser manages
the rendering of HTML controls. You can adjust the appearance of
the Web DataWindow by repositioning the control or resizing the
column.
Using existing DataWindow objects
Many existing DataWindow objects work in the Web DataWindow.
If a DataWindow object uses features that the Web DataWindow does
not support, then the features are ignored. You can still use the
DataWindow object if the remaining functionality is acceptable for
your application. For example: if the DataWindow includes a graph
control, the graph is ignored; if the DataWindow uses the Graph
presentation style, the DataWindow object will not be useful.
Supported and unsupported features
DataWindow feature |
Supported and unsupported |
||
---|---|---|---|
Presentation styles |
All presentation styles except OLE, Graph, |
||
Nested and composite reports |
Supported for the XHTML format only. |
||
Controls |
Supported controls: Column, Computed These controls are ignored: OLE Object, OLE Database Blob, Report controls are supported in XHTML Web DataWindows only. Rectangles cannot be rendered in a Label DataWindow with any The following Rectangle properties are not supported: moveable, GroupBoxes cannot be rendered in Crosstab and Grid style DataWindows. The following GroupBox properties are not supported: moveable, Only horizontal Line controls are supported. The line’s For information on:
|
||
Retrieving data |
Up to 16 retrieval arguments are supported. User-specified queries using the QueryMode property are not |
||
Updating data |
Same as the PowerBuilder DataWindow control. |
||
Edit styles |
All edit styles are supported except |
||
DDCalendar EditMask property |
The DDCalendar EditMask property option
For more information, see “Using a drop-down calendar “. |
||
DropDownDataWindows |
A drop-down DataWindow must be in the |
||
Display formats |
Supported, including the use of color. |
||
Validation rules |
The expression might be evaluated on For information, see “Using expressions”. |
||
Property expressions |
Evaluated on the server. |
||
Layout |
Properties that specify autosizing of |
||
Properties |
The following properties are not supported:
The Limit property is not supported in multiline edit columns |
||
Tab order |
Supported in HTML 4 and later browsers. |
Using a drop-down calendar
The drop-down calendar DataWindow option is available for
use on any DataWindow column with an EditMask, and a Date, DateTime,
or TimeStamp datatype. The DDCalendar EditMask property option allows
for separate selections of the calendar month, year, and date. This
option can be set in a check box on the Edit tab of the DataWindow
painter Properties view when a column with the EditMask edit style
is selected. It can also be set in code, as in this example for
the birth_date column:
1 |
dw_1.Modify("birth_date.EditMask.DDCalendar='Yes'") |
You can set the following properties to control the display
of the calendar in a script or on the Other page in the Properties
view for the column:
Painter option |
Property |
---|---|
Drop Align Right |
Column.Editmask.ddcal_alignright |
CalendarBackColor |
Column.Editmask.ddcal_backcolor |
CalendarTextColor |
Column.Editmask.ddcal_textcolor |
CalendarTitleBackColor |
Column.Editmask.ddcal_titlebackcolor |
CalendarTitleTextColor |
Column.Editmask.ddcal_titletextcolor |
CalendarTrailingTextColor |
Column.Editmask.ddcal_trailingtextcolor |
To make sure that dates selected with the drop-down calendar
option are displayed with the desired edit mask for Web DataWindows,
you should specify that the Client Formatting option be included
with the static JavaScript generated and deployed for the DataWindow.
To conserve bandwidth, JavaScript for client formatting is not included
by default. To include this script, you can select the Client Formatting
check box on the Web Generation page of the DataWindow Properties
view. If you do not include script for client formatting, the drop–down
calendar will use a default edit mask to display the column data
based on the client machine’s default localization settings.
To navigate in the drop–down calendar, a user can:
-
Click the arrows in the top corners to move from
month to month. -
Click the month to display a list of months, then
click a month to select it. -
Click the year to display a spin control, then use
the spin control’s arrows to select a year. -
Click a date to select the date and close the calendar.
-
Press the Esc key to close the calendar without
changing the selection.