Controls in a DataWindow and their properties

Notes:

  • Avoid placing controls above or behind other controls in a DataWindow, as overlapping controls are displayed differently on the Web than in PowerBuilder. For example, if there is a Text control behind a DropDownDataWindow column in a DataWindow, the DropDownDataWindow field cannot be pulled down correctly.

Button control

Supported

If a property is marked as "supported (r)" or "(r)", it means that the property can be read - but not changed - in script, and properties set in the painter will not take effect in the converted application.

If a property is marked as "supported (r/w)" or "(r/w)", it means that the property can be read or changed in script, and properties set in the painter will take effect.

Table 252. 

Property

What's Supported

What's Unsupported

Action

(r/w): User Defined, Retrieve, PageNext, PagePrior, PageFirst, PageLast, Sort, Filter, DeleteRow, AppendRow, InsertRow, Update, SaveRowsAs, Print, Cancel, Preview, PreviewWithRulers, QueryMode, QuerySort, Query, Clear

This property cannot be set by using DataWindow expression.

Retrieve (Yield)

Attributes

Supported (r)

 

Background​.property

Fully supported (r/w): Color, Mode

This property can be set by using DataWindow expression.

 

Band

Supported (r): Band, Background, Foreground

 

Color

Fully supported (r/w)

This property can be set by using DataWindow expression.

 

DefaultPicture

Supported (r/w)

This property cannot be set by using DataWindow expression.

 

Filename

Fully supported (r/w)

 

Font.property

(r/w): Charset, Escapement, Face, Family, Height, Italic, Pitch, Strikethrough, Underline, Weight

Note:

  1. When the value of Escapement is a negative number, the text will not be rotated.

  2. The text rotated can be displayed out of the control in PowerBuilder, but not in the Web application.

  3. After rotated, the multiple-line text still displays in multiple lines in PowerBuilder, but displays in one line on Web.

Width

Height

Fully supported (r/w)

This property can be set by using DataWindow expression.

 

HTextAlign

Fully supported (r/w)

 

Name

Supported (r)

 

Pointer

Fully supported (r/w)

 

SlideLeft

Supported (r/w)

 

SlideUp

Supported (r/w)

 

Tag

Fully supported (r/w)

 

Text

Fully supported (r/w)

 

Type

Supported (r)

 

VTextAlign

Supported (r/w)

 

Visible

Fully supported (r/w)

This property can be set by using DataWindow expression.

 

Width

Fully supported (r/w)

This property can be set by using DataWindow expression.

 

X

Fully supported (r/w)

This property can be set by using DataWindow expression.

 

Y

Fully supported (r/w)

This property can be set by using DataWindow expression.

 

Unsupported

  • HideSnaked

  • Movable

  • Resizable

  • SuppressEventProcessing

Column control

Supported

If a property is marked as "supported (r)" or "(r)", it means that the property can be read - but not changed - in script, and properties set in the painter will not take effect in the converted application.

If a property is marked as "supported (r/w)" or "(r/w)", it means that the property can be read or changed in script, and properties set in the painter will take effect.

Table 253. 

Property

What's Supported

What's Unsupported

Accelerator

Fully supported (r/w)

 

Alignment

Left!, Center!, Right!

In PowerBuilder, when the Edit.password property is YES and the alignment of the column's text is center-aligned, the text is left-aligned when it is being edited. After the editing, the text is center-aligned. In the Web application, the text is always center-aligned.

Justify!

Attributes

Supported (r)  

Background.​property

Fully supported (r/w): Color, Mode

 

Band

(r): Band

 

BitmapName

Fully supported (r/w)

Different from PB, Appeon also supports specifying an Internet URL as the column's content when BitmapName is set to Yes.

 

Border

(r/w): NoBorder!, Box!, Lowered!, Raised!, ShadowBox!, Underline!, ResizeBorder!

 

CheckBox.​property

(r/w): LeftText, Off, On, Other, Scale, Text, ThreeD, ThreeState

It is unsupported to dynamically change the edit style of a column by modifying this property.

Color

Fully supported (r/w)

Set this property using DataWindow expression.

 

ColType

Supported (r)

dw_control.object.columnname.coltype
dw_control.Describe("columnname.coltype")
 

Criteria.property

Fully supported (r/w)

 

dbName

Supported (r)

Example:

dw_control.object.columnname.dbName
dw_control.Describe("columnname.dbName")
 

dddw.property

(r/w): AllowEdit, AutoHScroll, AutoRetrieve, DataColumn, DisplayColumn, HscrollBar, Limit, Name, NilIsNull, PercentWidth, Required, UseAsBorder, VscrollBar, Case Lines, ShowList.

(r): HSplitScroll

The size and font size of Web DropdownDataWindows are determined by the size of the deployed DataWindow; the width of Web DropdownDataWindows, if set to be smaller than the column width, will be displayed in the same width as the column.

When executing Modify function to change the Dddw.property on the Web, the value variable must be contained in single quotation marks. For example,

Unsupported code:

dw_1.Modify (""emp_id.dddw.name = dw_dddw_dropdown"")

Supported code:

dw_1.Modify (""emp_id.dddw.name = 'dw_dddw_dropdown'"")

It is unsupported to dynamically change the edit style of a column by modifying this property.

ddlb.property

(r/w): AllowEdit, AutoHScroll, Case, Limit, NilIsNull, Required, ShowList, Sorted, UseAsBorder, VScrollBar

It is unsupported to dynamically change the edit style of a column by modifying this property.

Edit.property

(r/w): AutoHScroll, AutoSelect, AutoVScroll, Case, CodeTable, DisplayOnly, HscrollBar, Limit, Name, NilIsNull, Password, Required, Style, VscrollBar, FocusRectangle, ValidateCode

Format is unsupported.

Modifying ValidateCode takes no effect.

It is unsupported to dynamically change the edit style of a column by modifying this property.

EditMask.property

(r/w): AutoSkip, CodeTable, DDCalendar, Mask, ReadOnly, Required, Spin, SpinIncr, SpinRange, UseFormat, FocusRectangle

In the Web application, if the Mask of a column is set to [General], the values in the column are all displayed as integers when the column gets focus.

In the Web application, if the Mask is set to General by default, the displaying data of a column with the EditMask edit style will be converted into an integer when the column gets focus.

For more about the supported display formats, see Displaying and validating data.

If a Mask is set as a four-digit string, the column will only retrieve the first four digits of the entered value when you use SetItem to set a value in the EditMask column which is different from what occurs in PowerBuilder.

It is unsupported to dynamically change the edit style of a column by modifying this property.

Font.property

(r/w): Charset, Escapement, Face, Family, Height, Italic, Pitch, Strikethrough, Underline, Weight

Note:

  1. When the value of Escapement is a negative number, the text will not be rotated.

  2. The text rotated can be displayed out of the control in PowerBuilder, but not in the Web application.

  3. After rotated, the multiple-line text still displays in multiple lines in PowerBuilder, but displays in one line on Web.

Width

Format

Edit

For more about the supported display formats, see Displaying and validating data.

 

Height

Set the Height property using a DataWindow expression.

 

Height.AutoSize

Supported (r)

 

HideSnaked

Supported (r)

 

Identity

Fully supported (r/w)

 

ID

Supported (r)

 

Initial

Fully supported (r/w)

 

Key

Fully supported (r/w)

 

LineRemove

Supported (r)

 

Multiline

Fully supported (r/w)

 

Name

Supported (r)

 

Pointer

Supported (r/w)

 

Protect

This property can be set by using DataWindow expression.

 

RadioButtons​.property

Fully supported (r/w): 3D, Columns, LeftText, Scale

It is unsupported to dynamically change the edit style of a column by modifying this property.

RightToLeft

Supported

This property is partially supported. It only supports the right-to-left display of characters.

 

SlideLeft

Supported (r/w)

 

SlideUp

Supported (r/w)

 

TabSequence

Fully supported (r/w)

 

Tag

Fully supported (r/w)

 

Type

Supported (r)

 

Update

Fully supported (r/w)

 

Validation

Supported (r)

This property cannot be dynamically changed.

ValidationMsg

Supported (r/w)

 

Values

Supported (r/w)

This property is supported for columns with the following edit styles: DropDownListBox, CheckBox, and RadioButtons.

 

Visible

Supported (r/w)

This property can be set by using DataWindow expression.

 

Width

Fully supported (r/w)

This property can be set by using DataWindow expression.

 

Width.Autosize

Supported (r)

 

X

Supported (r/w)

 

Y

Supported (r/w)

 

Unsupported

  • Movable

  • Resizable

  • HTML.property

Notes:

  1. Automatically adjusting the height of DropDownDataWindow and DropDownListBox objects in Column controls is unsupported.

  2. Make sure that the length of data you specified for Column control in PowerBuilder exactly matches the length of data of the corresponding column in the database.

  3. It is unsupported to nest a DropDownDataWindow with another DropDownDataWindow.

Computed Field control

Supported

If a property is marked as "supported (r)" or "(r)", it means that the property can be read - but not changed - in script, and properties set in the painter will not take effect in the converted application.

If a property is marked as "supported (r/w)" or "(r/w)", it means that the property can be read or changed in script, and properties set in the painter will take effect.

LineRemove Supported (r)

Table 254. 

Property

What's Supported

What's Unsupported

Alignment

Fully supported (r/w): Left!, Center!, Right!

Justify!

Attributes

Supported (r)

 

Background​.property

Fully supported (r/w): Color, Mode

 

Band

Fully supported

 

Border

(r/w): NoBorder!, Box!, Lowered!, Raised!, ShadowBox!, Underline!, ResizeBorder!

 

Color

Fully supported (r/w)

This property can be set by using DataWindow expression.

 

ColType

Supported (r)

 

Expression

Supported (r/w)

Note:

  1. After dynamically modifying this property in CrossTab DataWindow, data will be recalculated according to the new expression on the Web. In PowerBuilder, the data will not be recalculated.

  2. If the expression starts with spaces (for example, ' ' + mail_from), in the Web application the computed field value after the spaces always starts in a new line, despite the column height. This is different from PowerBuilder.

 

Font.property

(r/w): Charset, Escapement, Face, Family, Height, Italic, Pitch, Strikethrough, Underline, Weight

Note:

  1. When the value of Escapement is a negative number, the text will not be rotated.

  2. The text rotated can be displayed out of the control in PowerBuilder, but not in Web applications.

  3. After rotated, the multiple-line text still displays in multiple lines in PowerBuilder, but displays in one line on Web.

Width

Format

Supported (r/w)

Null-format is unsupported; positive-format, negative-format, and zero-format are supported.

Height

Fully supported (r/w)

This property can be set by using DataWindow expression.

 

Height.Autosize

Supported

 

HideSnaked

Supported (r)

 

HTML.property

(r): AppendedHTML, Link, LinkArgs, LinkTarget, ValueIsHTML

 

Multiline

Supported

 

Name

Supported

 

Pointer

Supported

 

SlideLeft

Supported

 

SlideUp

Supported

 

Tag

Supported

 

Type

Supported

 

Visible

Supported

 

Width

Supported

 

Width.Autosize

Supported

 

X

Supported

 

Y

Supported

 

Unsupported

  • Movable

  • Resizable

Graph control

Supported

If a property is marked as "supported (r)" or "(r)", it means that the property can be read - but not changed - in script, and properties set in the painter will not take effect in the converted application.

If a property is marked as "supported (r/w)" or "(r/w)", it means that the property can be read or changed in script, and properties set in the painter will take effect.

Table 255. 

Property

What's Supported

What's Unsupported

Attributes

Fully supported

 

Axis

Fully supported

 

Axis.property

Fully supported

 

Axis.DispAttr

Fully supported

 

BackColor

Fully supported

 

Border

Fully supported

 

Category

Fully supported

 

Category.property

Fully supported

 

Category.DispAttr

Fully supported

 

Color

Fully supported

 

Depth

Fully supported

 

Elevation

Fully supported

 

GraphType

(r/w): AreaGraph!, BarGraph!, BarStackGraph!, Bar3DObjGraph!, BarStack3DObjGraph!, Col3DObjGraph!, ColStack3DObjGraph!, ColGraph!, ColStackGraph!, LineGraph!, PieGraph!, ScatterGraph!

Area3D!, Bar3DGraph!, Col3DGraph!, Line3D!, Pie3D!

Height

Fully supported

 

HideSnaked

Fully supported

 

Legend

Fully supported

 

Legend.DispAttr​.property

Fully supported

 

Name

Fully supported

 

OverlapPercent

Fully supported

 

Perspective

Fully supported

 

Pie.DispAttr​.fontproperty

Fully supported

 

Pointer

Fully supported

 

Range

Fully supported

 

Rotation

Fully supported

 

Series

Fully supported

 

Series.property

Fully supported

 

Series.DispAttr

Fully supported

 

ShadeColor

Fully supported

 

SizeToDisplay

Fully supported

 

SlideLeft

Fully supported

 

SlideUp

Fully supported

 

Spacing

Fully supported

 

Tag

Fully supported

 

Title

Fully supported

 

Title.DispAttr.fontproperty

Fully supported

 

Type

Fully supported

 

Values

Fully supported

 

Values.property

Fully supported

 

Values.DispAttr

Fully supported

 

Visible

Fully supported

 

Width

Fully supported

 

X

Fully supported

 

Y

Fully supported

 

Unsupported

  • Movable

  • Resizable

GroupBox control

Supported

If a property is marked as "supported (r)" or "(r)", it means that the property can be read - but not changed - in script, and properties set in the painter will not take effect in the converted application.

If a property is marked as "supported (r/w)" or "(r/w)", it means that the property can be read or changed in script, and properties set in the painter will take effect.

Table 256. 

Property

What's Supported

What's Unsupported

Attributes

Supported (r)

 

Background.property

Fully supported (r/w): Color, Mode

 

Band

Supported (r)

 

Border

Supported (r)

 

Color

Fully supported (r/w)

 

Font.property

(r/w): Charset, Escapement, Face, Family, Height, Italic, Pitch, Strikethrough, Underline, Weight

Note:

  1. When the value of Escapement is a negative number, the text will not be rotated.

  2. The text rotated can be displayed out of the control in PowerBuilder, but not in Web applications.

  3. After rotated, the multiple-line text still displays in multiple lines in PowerBuilder, but displays in one line on Web.

Width

Height

Fully supported (r/w)

 

HideSnaked

Supported (r)

 

Name

Supported (r)

 

Pointer

Fully supported (r/w):

 

SlideLeft

Supported (r/w):

 

SlideUp

Supported (r/w):

 

Tag

Fully supported (r/w)

 

Text

Fully supported (r/w)

 

Type

Supported (r)

 

Visible

Fully supported (r/w)

 

Width

Fully supported (r/w)

 

X

Fully supported (r/w)

 

Y

Fully supported (r/w)

 

Unsupported

  • Movable

  • Resizable

Line control

Supported

If a property is marked as "supported (r)" or "(r)", it means that the property can be read - but not changed - in script, and properties set in the painter will not take effect in the converted application.

If a property is marked as "supported (r/w)" or "(r/w)", it means that the property can be read or changed in script, and properties set in the painter will take effect.

Table 257. 

Property

What's Supported

What's Unsupported

Attributes

Supported (r)

 

Background​.property

(r/w): Color, Mode

 

Band

Supported (r)

 

Name

Supported (r)

 

Pen.property

Fully supported (r/w)

 

Pointer

Fully supported (r/w)

 

SlideLeft

Fully supported (r/w)

 

SlideUp

Fully supported (r/w)

 

Tag

Fully supported (r/w)

 

Type

Supported

 

Visible

Fully supported (r/w)

 

X1, X2

Fully supported (r/w)

 

Y1, Y2

Fully supported (r/w)

 

Unsupported

  • Movable

  • Resizable

Oval control

Supported

If a property is marked as "supported (r)" or "(r)", it means that the property can be read - but not changed - in script, and properties set in the painter will not take effect in the converted application.

If a property is marked as "supported (r/w)" or "(r/w)", it means that the property can be read or changed in script, and properties set in the painter will take effect.

Table 258. 

Property

What's Supported

What's Unsupported

Attributes

Supported(r)

 

Background​.property

Fully supported (r/w): Color, Mode

 

Band

Supported (r)

 

Brush.property

(r/w): Color, Hatch

 

Height

Supported (r/w)

 

HideSnaked

Supported (r)

 

Name

Fully supported

 

Pen.property

(r/w): Color, Style, Width

 

Pointer

Fully supported (r/w)

 

SlideLeft

Supported (r/w)

 

SlideUp

Supported (r/w)

 

Tag

Fully supported (r/w)

 

Type

Supported (r)

 

Visible

Fully supported (r/w)

 

X

Fully supported (r/w)

 

Y

Fully supported (r/w)

 

Unsupported

  • Movable

  • Resizable

Picture control

Supported

If a property is marked as "supported (r)" or "(r)", it means that the property can be read - but not changed - in script, and properties set in the painter will not take effect in the converted application.

If a property is marked as "supported (r/w)" or "(r/w)", it means that the property can be read or changed in script, and properties set in the painter will take effect.

Table 259. 

Property

What's Supported

What's Unsupported

Attributes

Supported(r)

 

Band

Supported (r)

 

Border

Fully supported (r/w)

 

Filename

Fully supported (r/w)

 

Height

Fully supported (r/w)

 

HideSnaked

Supported (r)

 

HTML.property

(r): AppendedHTML, Link, LinkArgs, LinkTarget

 

Invert

Supported (r)

 

Name

Supported (r)

 

Pointer

Supported (r/w):

 

SlideLeft

Supported (r/w)

 

SlideUp

Supported (r/w)

 

Tag

Fully supported (r/w)

 

Type

Supported (r)

 

Visible

Fully supported (r/w)

 

Width

Fully supported (r/w)

 

X

Fully supported (r/w)

 

Y

Fully supported (r/w)

 

Unsupported

  • Movable

  • Resizable

Rectangle control

Supported

If a property is marked as "supported (r)" or "(r)", it means that the property can be read - but not changed - in script, and properties set in the painter will not take effect in the converted application.

If a property is marked as "supported (r/w)" or "(r/w)", it means that the property can be read or changed in script, and properties set in the painter will take effect.

Table 260. 

Property

What's Supported

What's Unsupported

Attributes

Supported (r)

 

Background​.property

Fully supported (r/w): Color, Mode

 

Band

Supported (r)

 

Brush.property

(r/w): Color, Hatch

 

Height

Fully supported (r/w)

 

HideSnaked

Supported (r)

 

Name

Supported (r)

 

Pen.property

(r/w): Color, Style, Width

 

Pointer

Fully supported (r/w)

 

SlideLeft

Supported (r/w)

 

SlideUp

Supported (r/w)

 

Tag

Fully supported (r/w)

 

Type

Supported (r)

 

Visible

Fully supported (r/w)

 

X

Fully supported (r/w)

 

Y

Fully supported (r/w)

 

Unsupported

  • Movable

  • Resizable

Report control

Supported

If a property is marked as "supported (r)" or "(r)", it means that the property can be read - but not changed - in script, and properties set in the painter will not take effect in the converted application.

If a property is marked as "supported (r/w)" or "(r/w)", it means that the property can be read or changed in script, and properties set in the painter will take effect.

Table 261. 

Property

What's Supported

What's Unsupported

Attributes

Fully supported

 

Band

Fully supported

 

Border

Fully supported

 

DataObject

Supported (r/w)

DataWindows with the following presentation styles cannot be the DataObject: RichText, OLE and TreeView.

Height

Fully supported

 

Name

Fully supported

 

Nested Arguments

Fully supported

 

NewPage

Supported

 

Pointer

Fully supported

 

Slideleft

Supported

SlideUp

Supported

 

Tag

Fully supported

 

Trail footer

Supported

 

Type

Fully supported

 

Visible

Fully supported

 

X

Fully supported

 

Y

Fully supported

 

Unsupported

  • Criteria

  • HideSnaked

  • Movable

  • Resizable

Note:

  • In a single data retrieval, the number of report queries cannot be over 65,535.

  • It is unsupported to assign a nested report to a DataWindow object.

    Unsupported example:

    Dwobject ldwo
    String  ls_1
    Ldwo = Dw_1.object.dw_report[1]  // dw_report is a nested report.
    Ls_1 = ldwo.object.lastname[2]
    

    Supported example:

    Ls_1 = Dw_1.object.dw_report[1].object.lastname[2]

RoundRectangle control

Supported

If a property is marked as "supported (r)" or "(r)", it means that the property can be read - but not changed - in script, and properties set in the painter will not take effect in the converted application.

If a property is marked as "supported (r/w)" or "(r/w)", it means that the property can be read or changed in script, and properties set in the painter will take effect.

Table 262. 

Property

What's Supported

What's Unsupported

Attributes

Supported (r)

 

Background​.property

(r/w): Color, Mode

 

Band

Supported (r)

 

Brush.property

(r/w): Color, Hatch

 

Height

Fully supported(r/w)

 

HideSnaked

Supported (r)

 

Name

Supported (r)

 

Pen.property

(r/w): Color, Style, Width

 

Pointer

Fully supported(r/w)

 

SlideLeft

Supported (r/w)

 

SlideUp

Supported (r/w)

 

Tag

Fully supported (r/w)

 

Type

Supported (r)

 

Visible

Fully supported (r/w)

 

X

Fully supported (r/w)

 

Y

Fully supported (r/w)

 

Unsupported

  • Movable

  • Resizable

Text control

Supported

If a property is marked as "supported (r)" or "(r)", it means that the property can be read - but not changed - in script, and properties set in the painter will not take effect in the converted application.

If a property is marked as "supported (r/w)" or "(r/w)", it means that the property can be read or changed in script, and properties set in the painter will take effect.

Table 263. 

Property

What's Supported

What's Unsupported

Alignment

Fully supported (r/w): Left!, Center!, Right!

Justify!

Attributes

Supported (r)

 

Background​.property

Fully supported (r/w): Color, Mode

 

Band

Supported (r): Band

Background, Foreground

Border

(r/w): NoBorder!, Box!, Lowered!, Raised!, ShadowBox!, Underline!, ResizeBorder!

 

Color

Supported (r/w)

This property can be set by using DataWindow expression.

 

Font.property

(r/w): Charset, Escapement, Face, Family, Height, Italic, Pitch, Strikethrough, Underline, Weight

Note:

  1. When the value of Escapement is a negative number, the text will not be rotated.

  2. The text rotated can be displayed out of the control in PowerBuilder, but not in Web applications.

  3. After rotated, the multiple-line text still displays in multiple lines in PowerBuilder, but displays in one line on Web.

Width

Height

Fully supported (r/w) s

This property can be set by using DataWindow expression.

 

HideSnaked

Supported (r)

 

HTML.property

(r): AppendedHTML, Link, LinkArgs, LinkTarget, ValueIsHTML

 

Name

Supported (r)

 

Pointer

Fully supported(r/w)

 

SlideLeft

Supported (r/w)

 

SlideUp

Supported (r/w)

 

Tag

Fully supported (r/w)

 

Text

Supported (r/w)

 

Type

Supported (r)

 

Visible

Fully supported (r/w)

This property can be set by using DataWindow expression.

 

Width

Fully supported (r/w)

This property can be set by using DataWindow expression.

 

X

Fully supported (r/w)

This property can be set by using DataWindow expression.

 

Y

Fully supported (r/w)

This property can be set by using DataWindow expression.

 

Unsupported

  • Height.AutoSize

  • Movable

  • Resizable

Unsupported controls

The properties of all the following unsupported controls are unsupported:

  • InkPicture

  • OLE

  • TableBlob