DataWindow object properties

Supported

If a property is marked as "supported (r)" or "(r)", it means that the property can be read in script, but not changed in script, and setting the property in the painter has no 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 setting the property is effective in the painter.

The table below lists the supported properties for DataWindow object:

Table 249. 

Property

What's Supported

What's Unsupported

Attributes

Supported (r)

 

Bandname.property

(r/w): Detail.Color, Detail.Height, Detail.Height.Autosize, Detail.Pointer, Footer.Color, Footer.Height, Footer.Pointer, Header.Color, Header.Height, Header.Pointer, Summary.Color, Summary.Height, Summary.Pointer, Trailer.Color, Trailer.Height, Trailer.Pointer, Height.Autosize

 

Bandname.Text

Supported

 

Bands

Supported

 

BitmapName

Supported

 

Color

Supported

 

Column.count

Supported

 

Crosstab.property

(r/w): Crosstab.SourceNames (r): Rows, Columns, Values, StaticMode, CrossTabData

 

Data

Supported

 

Data.XML

Supported

 

Data.XMLDTD

Supported

 

Data.XMLSchema

Supported

 

FirstRowOnPage

Supported

 

Grid.ColumnMove

Supported

 

Grid.Lines

Supported

 

HTMLDW

Supported

 

HTML Gen​.property

Supported

 

HTML Table​.property

Supported

 

Label.property

Supported

 

LastRowOnPage

Supported (r)

 

Message.Title

Supported

 

Name

Supported

 

Nested

Supported

 

Objects

Fully supported (r)

Note: In the Web application, the returned object names are listed in a different order from that in PowerBuilder.

 

Pointer

Supported

 

Print.property

Supported

(r/w): Color, Collate, Columns, Columns.Width, Copies, DocumentName, Duplex, Filename, Margin.Botton, Margin.Left, Margin.Right, Margin.Top, Orientation, Page.Range, Page.RangeInclude, Paper.Size, Paper.Source, Preview, Preview.Rulers, Preview.Zoom, PrinterName, Prompt, Quality, Scale, CustomPage.Width, CustomPage.Length

Notes:

  1. When Paper.Size is the default value (0), in PowerBuilder application, the default paper size for the printer will be used for the output; while in Appeon Web application, the paper size for the local printer will be used, but if it cannot be obtained, then the monitor screen size (for example 1024x768) will be used.

  2. In Appeon Web application, the Copies property will not take effect and only one copy will be printed.

  3. In Appeon Web application, the Scale property will not take effect and the output always prints as 100% of scale.

  4. The value of MarginBottom, MarginLeft, printMarginTop, MarginRight, PreviewZoom, Scale cannot be negative.

  5. In PowerBuilder, if a printer driver does not support scaling, scaling is not supported in either DataWindow printing or preview. However, in the same scenario on the Web, scaling can work in DataWindow preview.

  6. When executing PDF printing, if the DocumentName is an empty string, on the Web, the DataWindow will be automatically saved as naming DataWindow.pdf.

  7. Filename cannot be an empty string.

  8. Newspaper Columns Across option under Columns property is supported for all DataWindows except for composite and nested DataWindows.

Unsupported

CanUserDefaultPrinter, ClipText, OverridePrintJob

Print.Buttons

Supported

 

Print.Preview​.Buttons

Supported

 

Printer

Supported

 

Processing

Supported (r)

 

QueryClear

Supported

Note: By setting the QueryClear property to Yes, events that are triggered by the property on Web are different from those in PowerBuilder.

 

QueryMode

Supported

Extending support:

For columns of all types (except string), if the QueryMode is set to Yes, calling Find functions will take effect on the Web but not in PowerBuilder.

Limitations:

In the query mode, calling the following functions is not recommended because the result of calling functions on the Web is different from in PowerBuilder: InsertRow, DeleteRow, ResetUpdate, RowsDiscard, Update, SetItemStatus, Sort, GroupSort, CopyData, MoveData, GetFullState, SetFullState, GetChanges, SetChanges.

If the QueryMode is set to Yes, it is unsupported to insert or delete rows in a DataWindow.

If the QueryMode is set to Yes, retrieving data by column alias will cause errors on the Web.

QueryMode is unsupported in TreeView DataWindow.

If the QueryMode is set to Yes, executing DataWindow SaveAs function will not reset the query criteria on the Web.

 

QuerySort

Supported

 

ReadOnly

Supported (r)

 

Rows_Per_Detail

Supported

 

RichText.property

Supported

 

Selected

Unsupported

 

Selected.Data

Unsupported

 

Selected.Mouse

Supported

If the Selected.Mouse is set to Yes, it is unsupported to select multiple columns by pressing Shift and Ctrl keys.

ShowDefinition

Supported (r)

 

SlideLeft

Supported

 

SlideUp

Supported

 

Sparse

Supported

 

Storage

Unsupported

 

StoragePageSize

Unsupported

 

Syntax

Supported

 

Syntax.Data

Supported

 

Syntax.Modified

Supported

 

Table.property

(r/w): Arguments, CrosstabData, Data.Storage, Delete.Argument, Delete.Method, Delete.Type, Filter, Select.Attribute, Update.Argument, Update.Method, Update.Type, Select, GridColumns, Insert.Argument, Insert.Method, Insert.Type, Select.Attribute, Sort, Update.Argument, Update.Method, Update.Type, UpdateKeyInPlace, UpdateTable, UpdateWhere

(r): SQLSelect, Procedure

In PowerBuilder, the Table.Select property contains the escape character "~" But after the execution of the SetTransObject function, "~" will be removed. During parsing of the application, "~" will be translated into a newline return. After parsing, no "~" will be found in the Table.Select property.

In PowerBuilder, by default, the Ascending criteria will be included in the value of the Table.Sort property. However, in the Web application, the Sort is a string containing the sort criteria set by the user. Even though the string will not include the default Ascending criteria, the result will be the same as in PowerBuilder.

For a Web application that has more than one user accessing the same tables concurrently, set the DataWindow Table.UpdateWhere property to 1 ("Key and updatable columns") to avoid data loss.

Table.property is not supported for External data sources.

Tooltip.property

Supported:

Backcolor, Enabled, Icon, Isbubble, Tip, Title, Textcolor

Unsupported:

Delay.initial, Delay.visible

VerticalScroll​Maximum

Supported

 

VerticalScroll​Position

Supported

 

Units

Supported

Only the type of PowerBuilder units is supported

 

Zoom

Partially Supported

Notes:

  1. It is unsupported to zoom DataWindow object when the window' s size is also changing.

  2. The effect of a zoom factor appears differently in PowerBuilder than in the Web application.

 

Unsupported

None of the Graphical DataWindow properties are supported.

The table below lists the unsupported properties for DataWindow objects:

Table 250. 

Data.HTML.Table

Data.XMLWeb

HideGrayLine

Data.XSLFO

Font.Bias

Help.property

HorizontalScroll​Maximum

HorizontalScroll​Maximum2

HorizontalScroll​Position

HorizontalScroll​Position2

HorizontalScrollSplit

HTMLDW

OLE.Client.property

Retrieve.AsNeeded

Row.Resize

Table.sqlaction.​property

Timer_Interval