HomeAppeon Web | Appeon Mobile | Appeon PowerBuilderAppeon Online Help Center

DataWindowChild Object

Table 236. Functions

Support Level

Feature Name

Description

Supported

AcceptText

 

Supported

ClassName

 

Supported

ClassValues

 

Unsupported

CrosstabDialog

 

Unsupported

DBCancel

 

Unsupported

DBErrorCode

 

Unsupported

DBErrorMessage

 

Supported

DeletedCount

 

Supported

DeleteRow

 

Supported

Describe

 

Unsupported

ExportJson

 

Supported

Filter

 

Supported

FilteredCount

 

Supported

Find

 

Supported

FindGroupChange

 

Supported

GetBandAtPointer

 

Supported

GetBorderStyle

 

Supported

GetChanges

 

Supported

GetChild

 

Supported

GetClickedColumn

 

Supported

GetClickedRow

 

Supported

GetColumn

 

Supported

GetColumnName

 

Unsupported

GetContextService

 

Supported

GetFormat

 

Supported

GetItemDate

 

Supported

GetItemDateTime

 

Supported

GetItemDecimal

 

Supported

GetItemNumber

 

Supported

GetItemStatus

 

Supported

GetItemString

 

Supported

GetItemTime

 

Supported

GetNextModified

 

Supported

GetObjectAtPointer

 

Supported

GetParent

 

Supported

GetRow

 

Unsupported

GetRowFromRowID

 

Unsupported

GetRowIdFromRow

 

Supported

GetSelectedRow

 

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.

Supported

GetText

 

Unsupported

GetTrans

 

Unsupported

GetUpdateStatus

 

Supported

GetValidate

 

Supported

GetValue

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

Supported

GroupCalc

 

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 the three 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).

Unsupported

ImportJson

Unsupported

ImportJsonByKey

Supported

ImportString

Please see the notes for ImportFile.

Supported

InsertRow

 

Supported

IsSelected

 

Supported

ModifiedCount

 

Supported

Modify

If the Modify function is used to modify the WHERE clause of the DataWindow object's SQL SELECT statement, please make sure that the new SQL SELECT statement is correct in syntax. Otherwise, syntax errors can occur on the mobile application because PowerBuilder does not validate the statement whereas JavaScript does.

When executing Modify function to change the dddw.property on the mobile application, 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"

In PowerServer Mobile, the Modify function cannot be used to modify the database information.

Unsupported

OLEActivate

 

Unsupported

ReselectRow

 

Supported

Reset

 

Unsupported

ResetTransObject

 

Supported

ResetUpdate

 

Supported

Retrieve

 

Supported

RowCount

 

Supported

RowsCopy

 

Supported

RowsDiscard

 

Supported

RowsMove

 

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 = dwc_test.SaveAs(filename, saveastype, colheading, encoding)

    The unsupported SaveAs syntax:

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

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

    For example, the following syntax:

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

    will be executed as the following:

    dwc_1.SaveAs( filename, PDF!, true, EncodingANSI! )

  3. If the DataWindowchild without any data is saved as an HTML file, the header will not be saved in PowerServer Mobile, whereas it will be saved on PB.

  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 PowerServer 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

SaveNativePDFToBlob

 

Supported

ScrollNextPage

 

Supported

ScrollNextRow

 

Supported

ScrollPriorPage

 

Supported

ScrollPriorRow

 

Supported

ScrollToRow

 

Unsupported

SelectRow

 

Unsupported

SetBorderStyle

 

Supported

SetChanges

 

Supported

SetColumn

 

Supported

SetDetaHeight

 

Supported

SetFilter

 

Supported

SetFormat

 

Supported

SetItem

 

Supported

SetItemStatus

 

Supported

SetPositon

The following syntax is supported:

dwcontrol.SetPosition(position {, precedingobject })

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

The following syntax is unsupported:

dwcontrol.SetPosition(objectname, band, bringtofront)

Supported

SetRedraw

 

Supported

SetRow

 

Supported

SetRowFocusIndicator

 

Supported

SetSort

Using "desc" or "asc" as the Order will not have any effect. Please use the standard Order value A for ascending or D for descending order.

Supported

SetSQLPreview

 

Supported

SetSQLSelect

 

Supported

SetTabOrder

 

Supported

SetText

 

Unsupported

SetTrans

 

Supported

SetTransObject

 

Supported

SetValidate

 

Supported

SetValue

 

Supported

SetWSObject

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

Supported

ShareData

 

Supported

ShareDataOff

 

Supported

Sort

If the items in a DropDownDataWindow are double-byte (such as, Chinese, Korean, or Japanese), sorting the DropDownDataWindow has a different result from PowerBuilder. This is because the sorting method of PowerScript and JavaScript is different. For example, if the charset is Chinese, PowerScript sorts by the spelling while JavaScript sorts by Unicode.

Supported

TypeOf

 

Supported

Update

 

Table 237. Properties

Support Level

Feature Name

Description

Unsupported

ClassDefinition

 

Prev  Up  Next
Text  Home  DataWindow performance considerations