HomeAppeon Web | Appeon Mobile | Appeon PowerBuilderAppeon Online Help Center

Controls in a DataWindow and their properties

Button control
Column control
Computed Field control
Graph control
GroupBox control
Line control
Oval control
Picture control
Rectangle control
Report control
RoundRectangle control
Text control
Unsupported controls

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 263. 

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 264. 

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:

1) 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'"")

2) properties must be separated with spaces when they are concatenated into one value. For example,

Unsupported code:

dw_1.Modify = "emp_id.BackGround.Color=" + String(RGB(192,192,192)) + "emp_id.Protect=1"

Supported code:

dw_1.Modify = "emp_id.BackGround.Color=" + String(RGB(192,192,192)) + " emp_id.Protect=1"

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 265. 

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 266. 

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 267. 

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 268. 

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 269. 

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 270. 

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 271. 

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 272. 

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 273. 

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 274. 

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

Prev  Up  Next
DataWindow object properties  Home  DataWindow data and property expressions