DataWindow Control

Table 214. Events

Support Level

Feature Name

Description

Supported

ButtonClicked

 

Supported

ButtonClicking

 

Supported

Clicked

 

Supported

Collapsed

 

Supported

Collapsing

 

Supported

Constructor

 

Supported

DBError

The sqlsyntax and buffer arguments do not work in the DBError event.

The GetSQLPreview function will be ignored if used in the DBError event.

Supported

Destructor

 

Supported

DoubleClicked

 

Supported

DragDrop

 

Supported

DragEnter

 

Supported

DragLeave

 

Supported

DragWithin

 

Supported

EditChanged

 

Unsupported

Error

 

Supported

Expanded

 

Supported

Expanding

 

Supported

GetFocus

 

Unsupported

Help

 

Supported

ItemChanged

 

Supported

ItemError

 

Supported

ItemFocusChanged

 

Supported

LoseFocus

 

Unsupported

Other

 

Unsupported

PrintEnd

 

Supported

PrintPage

 

Unsupported

PrintStart

 

Supported

RButtonDown

For more about RButtonDown, see Common Features.

Supported

Resize

 

Supported

RetrieveEnd

 

Unsupported

RetrieveRow

 

Supported

RetrieveStart

 

Supported

RowFocusChanged

 

Supported

RowFocusChanging

 

Unsupported

ScrollHorizontal

 

Unsupported

ScrollVertical

 

Supported

SQLPreview

 

Supported

WSError

 


Table 215. Functions

Support Level

Feature Name

Description

Supported

AcceptText

 

Unsupported

CanUndo

 

Supported

CategoryCount

 

Supported

CategoryName

 

Supported

ClassName

 

Supported

Clear

 

Supported

ClearValues

 

Unsupported

Clipboard

 

Supported

Collapse

 

Supported

CollapseAll

 

Supported

CollapseAllChildren

 

Supported

Copy

 

Supported

CopyRTF

 

Supported

Create

 

Unsupported

CrosstabDialog

 

Supported

Cut

 

Supported

DataCount

 

Unsupported

DBCancel

 

Unsupported

DBErrorCode

 

Unsupported

DBErrorMessage

 

Supported

DeletedCount

 

Supported

DeleteRow

 

Supported

Describe

If there is no value for a property in the propertylist argument, Describe returns a question mark (?) in PowerBuilder, but returns the default value (for example, Arrow!) of the property on mobile.

Supported

Drag

For more about Drag, see Common Features.

Supported

Expand

 

Supported

ExpandAll

 

Supported

ExpandAllChildren

 

Supported

ExpandLevel

 

Supported

Filter

 

Supported

FilteredCount

 

Supported

Find

 

Supported

FindCategory

 

Supported

FindGroupChange

 

Supported

FindNext

 

Supported

FindSeries

 

Unsupported

GenerateHTMLForm

 

Unsupported

GenerateResultSet

 

Supported

GetBandAtPointer

 

Supported

GetBorderStyle

 

Supported

GetChanges

 

Supported

GetChild

 

Supported

GetClickedColumn

 

Supported

GetClickedRow

In a mobile application, if the user clicks or double-clicks any area within a DataWindow, the GetClickedRow function returns the same value as in PowerBuilder. If the GetClickedRow is called in some control or window for a DataWindow, the return value is different on mobile than in PowerBuilder. For example, if the dw_1.GetClickedRow() function is called in the Clicked event of a CommandButton, it returns -1 in PowerBuilder and 0 on mobile.

Supported

GetColumn

 

Supported

GetColumnName

 

Unsupported

GetContextService

 

Supported

GetData

 

Supported

GetDataPieExplode

 

Supported

GetDataStyle

 

Supported

GetDataValue

 

Supported

GetFormat

 

Supported

GetFullState

 

Supported

GetItemDate

 

Supported

GetItemDateTime

 

Supported

GetItemDecimal

 

Supported

GetItemFormattedString

 

Supported

GetItemNumber

 

Supported

GetItemStatus

 

Supported

GetItemString

 

Supported

GetItemTime

 

Supported

GetItemUnformattedString

 

Unsupported

GetMessageText

 

Supported

GetNextModified

 

Supported

GetObjectAtPointer

 

Supported

GetParent

 

Supported

GetRow

 

Supported

GetRowFromRowId

 

Supported

GetSelectedRow

 

Supported

GetSeriesStyle

 

Supported

GetSQLPreview

 

Supported

GetSQLSelect

If the syntax in DataWindow is PBSELECT statement, when calling the GetSQLSelect function, it will still return the PBSELECT statement but not the SQL SELECT statement, which is different from that in PowerBuilder.

Unsupported

GetStateStatus

 

Supported

GetText

 

Unsupported

GetTrans

 

Unsupported

GetUpdateStatus

 

Supported

GetValidate

 

Supported

GetValue

The column argument only works when the edit style of the column is CheckBox, DropDownListBox, Edit, or RadioButton.

Supported

GroupCalc

 

Supported

Hide

 

Unsupported

ImportClipboard

 

Supported

ImportFile

ImportFile & ImportString

  1. The filename argument of ImportFile function must be a tab-separated file (TXT) or a comma-separated file (CSV).

  2. The importtype arguments (e.g. Text!, CSV! and XML!) of ImportString function are unsupported.

    The importtype arguments (e.g. Text!, CSV!, XML!, DBase2!, DBase3!) of ImportFile function are unsupported.

  3. When using these functions, you should ensure that the data type imported matches the data type that you specified in a DataWindow control, DataStore object or graph control. Otherwise the output on mobile may be different from that in PowerBuilder. For example, if the date type specified in a DataWindow is string, when you import a file with date number (e.g., 2006-08-01), on mobile the date data will be recognized as a string (2006), however in PowerBuilder, it will be recognized as a date data (2006-08-01).

Supported

ImportString

Please see the notes for ImportFile.

Supported

InsertDocument

 

Supported

InsertRow

 

Supported

IsExpanded

 

Supported

IsSelected

 

Supported

LineCount

 

Supported

ModifiedCount

 

Supported

Modify

Refer to Dynamic DataWindow.

Supported

ObjectAtPointer

 

Unsupported

OLEActivate

 

Supported

Paste

 

Supported

PasteRTF

 

Supported

PointerX

 

Supported

PointerY

 

Unsupported

Position

 

Supported

PostEvent

 

Supported

Print

Mobile platform difference:

Supported in iOS, but unsupported in Android.

Unsupported

PrintCancel

 

Unsupported

ReselectRow

 

Supported

Reset

The unsupported syntax: Reset (dwcontrol).

The supported syntax: dwcontrol.Reset.

Supported

ResetDataColors

 

Unsupported

ResetInk

 

Unsupported

ResetTransObject

 

Supported

ResetUpdate

 

Supported

Resize

 

Supported

Retrieve

Because Appeon cannot check whether the retrieve result set matches the DataWindow definition syntax, the DBError event will not be triggered.

Supported

RowCount

 

Supported

RowsCopy

 

Supported

RowsDiscard

For Composite, Group and Label DataWindows, if the current row is the start row, calling RowDiscard will not trigger RowFocusChanged on mobile. This is different from that in PowerBuilder.

Supported

RowsMove

Events cannot be triggered while the application moves data within the primary buffer of one DataWindow.

Supported

SaveAs

  1. The saveastype argument can be TEXT, HTMLTable, PDF, or EXCEL. For the EXCEL format, only up to 256 characters are supported and anything larger will be automatically truncated.

  2. The supported SaveAs syntax:

    ll_testvalue = dw_test.SaveAs(filename, saveastype, colheading, encoding)

    The unsupported SaveAs syntax:

    dw_test.SaveAs()
    dw_test.SaveAs([filename, ]graphcontrol[, saveastype, colheading])

    Note: For Appeon Mobile, when saveastype is PDF, the colheading and encoding arguments will be always executed as true and EncodingANSI!.

    For example, the following syntax:

    dw_1.SaveAs( filename, PDF!, false, EncodingUTF16BE! )

    will be executed as the following:

    dw_1.SaveAs( filename, PDF!, true, EncodingANSI! )
  3. If the DataWindow without any data is saved as an HTML file, the header will not be saved in Appeon Mobile, whereas it will be saved on PB.SetSort.

  4. When the file is generated via the SaveAs function on the mobile device, its file name is always in lower case, no matter which case you specify for the file name. This is as designed by Appeon Mobile. And since the mobile OS (such as iOS, Android) uses a case-sensitive file system, therefore, it is recommended you use lower case for the file name when developing an app for the mobile device.

  5. The generated file is automatically saved to the "plugin" folder under the current application directory. See "plugin" folder in Workarounds & APIs Guide for more.

Unsupported

SaveAsAscii

When executing the SaveAsAscii function in PowerBuilder, invisible controls which lay in rows will not be saved as empty rows or " " (quotation marks). However, these invisible controls will be ignored on mobile.

Unsupported

SaveAsFormattedText

 

Unsupported

SaveInk

 

Unsupported

SaveInkPic

 

Unsupported

Scroll

 

Supported

ScrollNextPage

 

Supported

ScrollNextRow

 

Supported

ScrollPriorPage

 

Supported

ScrollPriorRow

 

Supported

ScrollToRow

 

Supported

SelectedLength

 

Supported

SelectedStart

 

Supported

SelectedText

 

Supported

SelectTextAll

 

Supported

SelectTextLine

 

Supported

SelectTextWord

 

Supported

SeriesCount

 

Supported

SeriesName

 

Unsupported

SetActionCode

 

Supported

SetBorderStyle

 

Supported

SetChanges

 

Supported

SetColumn

 

Supported

SetDataPieExplode

 

Supported

SetDataStyle

 

Supported

SetDetailHeight

Setting detail.height.autosize to true after specifying the height by this function, executing Describe returns the auto sized height on mobile. But in PowerBuilder it returns the height specified by this function.

Supported

SetFilter

 

Supported

SetFocus

 

Supported

SetFormat

 

Supported

SetFullState

 

Unsupported

SetHTMLAction

 

Supported

SetItem

 

Supported

SetItemStatus

 

Supported

SetPosition

The supported syntax:

dwcontrol.SetPosition(position {, precedingobject})

The position can be ToTop!, ToBottom!, but cannot be Behind!

The unsupported syntax

dwcontrol.SetPosition(objectname, band, bringtofront)

Supported

SetRedraw

See Common Features.

Supported

SetRow

 

Supported

SetRowFocusIndicator

 

Supported

SetSeriesStyle

 

Supported

SetSort

 

Supported

SetSQLPreview

 

Supported

SetSQLSelect

If a DataWindow uses a stored procedure as its data source, the SetSQLSelect function cannot be executed for the DataWindow.

Supported

SetTabOrder

 

Supported

SetText

 

Unsupported

SetTrans

 

Supported

SetTransObject

 

Supported

SetValidate

 

Supported

SetValue

The SetValue column argument only works if the edit style of the column is DropdownListBox.

Supported

SetWSObject

The SetWSObject function is used to set the authentication info for accessing Web service.

Supported

ShareData

ShareData and ShareDataOff

  1. Supported:

    CONNECT USING SQLCA;
    dw_corp.SetTransObject(SQLCA)
    dw_corp.Retrieve()
    dw_corp.ShareData(dw_emp)
    dw_corp.ShareData(dw_dept)
    ... // Some processing
    dw_emp.ShareDataOff( )
  2. In mobile applications, if any data in two data-sharing Group DataWindows are changed, the primary Group DataWindow will be re-grouped and re-sorted automatically, while the secondary Group DataWindow will only be re-grouped.

  3. The row and column status is shared between the primary DataWindow and secondary DataWindow on mobile, although not shared in PowerBuilder.

Supported

ShareDataOff

Please see the notes for ShareData.

Supported

Show

 

Supported

ShowHeadFoot

 

Supported

Sort

  1. Different from the Sort in PowerBuilder, the Sort function on mobile considers the "~" symbol to have precedence over characters. For this reason, the sort result may be a little different in mobile and PowerBuilder applications.

  2. In the mobile application, when the user sorts a DataWindow on a specified column, rows containing special characters (e.g. ".", "", "/") will be sorted in different order than in PowerBuilder.

Supported

TextLine

 

Supported

TriggerEvent

The following TriggerEvent syntax is unsupported:

object1.TriggerEvent (object2, event).

Supported

TypeOf

 

Supported

Undo

 

Supported

Update

 


Table 216. Properties

Property added by Appeon

Keyboardtype - Sets the type of the keyboard that displays when the DataWindow column gets focus: 0 - alphabetical keyboard, 1 - numerical keyboard, 2 - URL keyboard. 2 is unsupported on Android devices, thus 0 will be used instead.

You can manipulate this property though dot notation, Describe, or Modify , for example, dw_1.modify("#1.keyboardtype='2'").

Support Level

Feature Name

Description

Supported

Border

 

Supported

BorderStyle

BorderStyle is partially supported. For more, see Common Features.

Supported

BringToTop

 

Unsupported

ClassDefinition

 

Supported

ControlMenu

 

Supported

DataObject

 

Unsupported

DragAuto

 

Unsupported

DragIcon

 

Supported

Enabled

 

Supported

Height

 

Supported

HScrollBar

VScrollBar and HScrollBar will be displayed as the mobile-style scrollbar, rather than the Windows-style scrollbar.

Unsupported

HSplitScroll

 

Unsupported

Icon

 

Supported

LiveScroll

 

Supported

MaxBox

 

Supported

MinBox

 

Supported

Object

 

Supported

Resizable

The Resizable property cannot be dynamically changed.

After setting this property to True, setting Border properties will not be effective.

Supported

RightToLeft

 

Unsupported

TabOrder

See Common Features.

Supported

Tag

 

Unsupported

Title

 

Unsupported

TitleBar

 

Supported

Visible

 

Supported

VScrollBar

VScrollBar and HScrollBar will be displayed as the mobile-style scrollbar, rather than the Windows-style scrollbar.

Supported

Width

 

Supported

X

 

Supported

Y