Supported Objects

Application object

Important Requirements

  • There can only be one Application object in an application.

  • An application cannot be given the same name as a PowerBuilder control type. For example, naming an application "datawindow", "editmask" or "commandbutton" is not supported.

  • An application name cannot be a reserved word in JavaScript. See Identifiers for more information.

  • A commandline argument in the application Open event is supported.

  • It is recommended that the use of Application object is limited to the following well-supported actions:

    1. Launching login screens.

    2. Opening and closing MDI, SDI, Main, Response and Popup windows.

    3. Creating instances of one or more transaction objects.

Additional properties of Application object

  • You can specify an icon for the application, but the icon will be displayed in PowerBuilder only and will not be displayed on Web.

  • The type of SQLCA can be a transaction user object.

  • The type of SQLSA can be a DynamicStagingArea user object.

  • The type of SQLDA can be a DynamicDescriptionArea user object.

  • The variable type MESSAGE can use the default value "message" or a user-defined message object, and you can also customize the Message object by defining a class user object inherited from the built-in Message object.

  • The specification of Error will be ignored.

Properties for Application object

Table 118. 

Property

Support Level

Example Code

AppName

Supported

String ls_AppName

ls_AppName =app_1.AppName

//Get the AppName property

ClassDefinition

Unsupported

 

DDETimeOut

Unsupported

 

DisplayName

Supported

String ls_DisplayName

ls_DisplayName = app_1.DisplayName

DWMessageTitle

Unsupported

 

FreeDBLibraries

Unsupported

 

MicroHelpDefault

Supported

app_1.MicroHelpDefault = 'Ready'

RightToLeft

Supported

app_1.RightToLeft = TRUE

ToolbarFrameTitle

Supported

ls_value = app_1.ToolbarFrameTitle

ToolbarPopMenu​Tex

Unsupported

 

ToolbarSheetTitle

Supported

ls_value =app_1.ToolbarSheetTitle

ToolbarTips

Supported

lb_value = app_1.ToolbarTips

ToolbarText

Supported

lb_value = app_1.ToolbarText

ToolbarUser​Control

Supported

 

Events for Application object

Table 119. 

Event

Support Level

Example Code

Close

Supported

Close

Idle

Supported

Idle

Open

Supported

Open

Note: The commandline argument is supported. The Commandline argument cannot include continuous number signs ("#").

ConnectionBegin

Unsupported

 

ConnectionEnd

Unsupported

 

SystemError

Unsupported

 

Functions for Application object

Table 120. 

Function

Support Level

Example Code

ClassName

Supported

ls_class = l_app.ClassName()

GetParent

Supported

lobj_parent = l_app.GetParent()

PostEvent

Supported

l_app.PostEvent (Clicked!) l_app.PostEvent ("Clicked!")

TriggerEvent

Supported

l_app.TriggerEvent (Clicked!) l_app.TriggerEvent ("Clicked!")

TypeOf

Supported

string ls_applicationtype

if l_app.TypeOf()=Application! Then

ls_applicationtype = "Application!"

end if

GetContextService

Unsupported

 

SetLibraryList

Unsupported

 

SetTransPool

Unsupported

 

Note: in PowerBuilder 2017 and later versions, GetLibrary and SetLibrary are global functions.


Connection object

Important Requirements

Connection object can be created dynamically using the CREATE statement.

Properties for Connection object

Table 121. 

Property

Support Level

Example Code

Application

Supported

ls_name = myconnect.application

Driver

Supported

ls_driver = myconnect.Driver

Myconnect.Driver = "jaguar"

ErrCode

Supported

ll_rc = myconnect.errcode

ErrText

Supported

ll_rc = myconnect.errtext

Location

Supported

ls_location = myconnect.location

myconnect.location = "192.0.0.217:9000"

UserID

Supported

ls_userid = myconnect.UserID

myconnect.UserID = "jagadmin"

Password

Supported

ls_pwd = myconnect.Password

myconnect.Password = ""

ClassDefinition

Unsupported

 

ConnectString

Unsupported

 

Handle

Unsupported

 

Options

Unsupported

 

Trace

Unsupported

 

Events for Connection object

Table 122. 

Event

Support Level

Example Code

Constructor

Supported

Constructor

Destructor

Supported

Destructor

Error

Unsupported

 

Functions for Connection object

Table 123. 

Function

Support Level

Example Code

ClassName

Supported

ls_name = Myconnect.ClassName()

ConnectToServer

Supported

ll_rc = Myconnect.ConnectToServer()

Note: The return value is always 0 on the Web.

CreateInstance

Supported

ll_rc = Myconnect.CreateInstance(ln_tools,"simpletest/nvo_tools")

DisconnectServer

Supported

ll_rc = Myconnect.disconnectserver()

Note: The return value is always 0 on the Web.

GetParent

Supported

lobj_parent = Myconnect.GetParent()

PostEvent

Supported

lb_rc = Myconnect.PostEvent(event)

TriggerEvent

Supported

li_rc = Myconnect.TriggerEvent(event)

TypeOf

Supported

IF Myconnect.TypeOf() = Connection! THEN

ls_rc = "Connection"

END IF

GetContextService

Unsupported

 

GetServerInfo

Unsupported

 

Lookup

Unsupported

 

RemoteStop​Connection

Unsupported

 

RemoteStop​Listening

Unsupported

 

CORBAObject object

Important Requirements

The CORBAObject object can be created dynamically using the CREATE statement.

Properties for CORBAObject object

Table 124. 

Property

Support Level

Example Code

ClassDefinition

Unsupported

 

Events for CORBAObject object

Table 125. 

Event

Support Level

Example Code

Constructor

Supported

Constructor

Destructor

Supported

Destructor


Functions for CORBAObject object

Table 126. 

Function

Support Level

Example Code

ClassName

Supported

ls_name = my_corbaobj.ClassName()

GetParent

Supported

lobj_parent = my_corbaobj.GetParent()

PostEvent

Supported

lb_rc = my_corbaobj.PostEvent(event)

TriggerEvent

Supported

li_rc = my_corbaobj.TriggerEvent(event)

TypeOf

Supported

IF my_corbaobj.TypeOf() = CorbaObject! THEN

ls_rc = "Connection"

END IF

_Is_A

Unsupported

 

_Narrow

Unsupported

 

GetContextService

Unsupported

 

DynamicDescriptionArea object

Properties for DynamicDescriptionArea object

Table 127. 

Property

Support Level

Example Code

NumInputs

Supported

Integer li_input li_input = SQLDA.NumInputs

NumOutputs

Supported

Integer li_output

li_output = SQLDA.NumOutputs

InParmType[]

Supported

if SQLDA.InParmType[3] = TypeInteger! then ...

OutParmType[]

Supported

CHOOSE CASE SQLDA.OutParmType[li_Idx]

On the Web, the value of this property may differ from that in PowerBuilder.

ClassDefinition

Unsupported

 

Events for DynamicDescriptionArea object

Table 128. 

Event

Support Level

Example Code

Constructor

Supported

Constructor

Destructor

Supported

Destructor


Functions for DynamicDescriptionArea object

Table 129. 

Function

Support Level

Example Code

ClassName

Supported

ls_class = dsa_1.ClassName()

GetDynamicDate

Supported

ls_Value = String(SQLDA.GetDynamicDate(li_Idx))

GetDynamic​DateTime

Supported

ls_Value = String(SQLDA.GetDynamicDateTime(li_Idx))

GetDynamic​Number

Supported

ls_Value = String(SQLDA.GetDynamicNumber(li_Idx))

GetDynamic​String

Supported

ls_Value = SQLDA.GetDynamicString(li_Idx)

GetDynamicTime

Supported

ls_Value = String(SQLDA.GetDynamicTime(li_Idx))

GetParent

Supported

PowerObject lobj_parent_name

lobj_parent_name = this.GetParent ()

PostEvent

Supported

this.PostEvent (Clicked!)

this.PostEvent ("Clicked")

SetDynamicParm

Supported

SQLDA.SetDynamicParm(1,2004)

TriggerEvent

Supported

this.TriggerEvent (Clicked!)

this.TriggerEvent ("Clicked")

TypeOf

Supported

SQLSA.TypeOf()

GetContextService

Unsupported

 

DynamicStagingArea object

Important Requirements

The DynamicStagingArea object can be created dynamically using the CREATE statement.

Properties for DynamicStagingArea object

Table 130. 

Property

Support Level

Example Code

ClassDefinition

Unsupported

 

Events for DynamicStagingArea object

Table 131. 

Event

Support Level

Example Code

Constructor

Supported

Constructor

Destructor

Supported

Destructor


Functions for DynamicStagingArea object

Table 132. 

Function

Support Level

Example Code

ClassName

Supported

ls_class = dsa_1.ClassName()

Destructor

Supported

Destructor

Constructor

Supported

Constructor

GetParent

Supported

lobj_parent_name = this.GetParent ()

PostEvent

Supported

this.PostEvent (Clicked!)

this.PostEvent ("Clicked!")

TriggerEvent

Supported

this.TriggerEvent (Clicked!)

this.TriggerEvent ("Clicked!")

TypeOf()

Supported

SQLSA.TypeOf()

GetContextService

Unsupported

 

Environment object

Properties for Environment object

Table 133. 

Property

Support Level

Example Code

CharSet

Supported

 

CPUType

Supported

 

Language

Supported

 

MachineCode

Supported

 

OSFixesRevision

Supported

 

OSMajorRevision

Supported

 

OSMinorRevision

Supported

 

PBFixesRevision

Supported

 

PBMajorRevision

Supported

 

PBMinorRevision

Supported

 

NumberOfColors

Supported

 

ScreenHeight

Supported

 

ScreenWidth

Supported

 

OSType

Supported

 

PBType

Supported

 

Win16

Supported

 

ClassDefinition

Unsupported

 

Functions for Environment object

Table 134. 

Function

Support Level

Example Code

ClassName

Supported

string varname

varname = ClassName(gd_double)

TypeOf

Supported

dw_1.Typeof()

GetContextService

Unsupported

 

GetParent

Unsupported

 

Graph object

Properties for Graph object

Table 135. 

Property

Support Level

Example Code

BackColor

Supported

gr_1.BackColor = RGB(255, 255, 0)

Note: transparent value is unsupported.

Border

Supported

gr_1.Border = TRUE

BorderStyle

Supported

gr_1.BorderStyle = StyleLowered!

BringToTop

Supported

gr_1.BringToTop = TRUE

Category

Supported

gr_1.Category.Label = "Types of Products"

CategorySort

Supported

gr_1.CategorySort = Unsorted!

Note: If the values of Category are multibyte characters (for example, Chinese characters), they are sorted by internal statement number on the Web.

Depth

Supported

gr_1.Depth = 50

DragAuto

Supported

gr_1.DragAuto = TRUE

DragIcon

Supported

gr_1.DragIcon = 'Question!'

Elevation

Supported

gr_1.Elevation = 35

Enabled

Supported

gr_1.Enabled = TRUE

FocusRectangle

Supported

gr_1.FocusRectangle = TRUE

GraphType

Supported

gr_1.GraphType= AreaGraph!

Note: The following graph types are unsupported: Area3D!, Bar3DGraph!, Col3DGraph!, Line3D!, Pie3D!

Height

Supported

gr_1.Height = 750

Legend

Supported

gr_1.Legend = AtBottom!

LegendDispAttr

Supported

 

OverlapPercent

Supported

gr_1.OverlapPercent = 10

Perspective

Supported

gr_1.Perspective = 25

PieDispAttr

Supported

 

Pointer

Supported

gr_1.Pointer = 'Beam!'

gr_1.Pointer = 'd:\archive\IBEAM.BMP'

Rotation

Supported

gr_1.Rotation = -45

Series

Supported

gr_1.Series.Scaletype = Log10!

SeriesSort

Supported

gr_1.SeriesSort = Unsorted!

Note:

  1. The result of executing this property on the Web may differ from that in PowerBuilder. This is because changing other properties may affect the SeriesSort property in PowerBuilder but it does not have such effect on the Web.

  2. If the values of Category are multibyte characters (for example, Chinese characters), they are sorted by internal statement numbers on the Web.

ShadeColor

Supported

dw_1.Object.gr_1.ShadeColor = 16600000

Spacing

Supported

gr_1.Spacing = 120

TabOrder

Supported

gr_1.TabOrder = 10

Tag

Supported

gr_1.SetMicroHelp(This.Tag)

TextColor

Supported

gr_1.Series.DispAttr.TextColor = RGB(0,0,255)

Title

Supported

gr_1.TitleBar = TRUE

gr_1.Title = "Monthly Report"

TitleDispAttr

Supported

 

Values

Supported

ls_value = dw_1.Object.gr_1.Values

Visible

Supported

gr_1.Visible = TRUE

Width

Supported

gr_1.Width = 750

X

Supported

gr_1.X = 215

Y

Supported

gr_1.Y= 400

ClassDefinition

Unsupported

 

Transparency

Unsupported

 

Events for Graph object

Table 136. 

Event

Support Level

Example Code

Clicked

Supported

Clicked

Constructor

Supported

Constructor

Destructor

Supported

Destructor

DoubleClicked

Supported

DoubleClicked

DragDrop

Supported

DragDrop

DragEnter

Supported

DragEnter

DragLeave

Supported

GragLeave

DragWithin

Supported

DragWithin

GetFocus

Supported

GetFocus

LoseFocus

Supported

LoseFocus

RButtonDown

Supported

RButtonDown

Help

Unsupported

 

Other

Unsupported

 

Functions for Graph object

Table 137. 

Function

Support Level

Example Code

AddCategory

Supported

gr_1.AddCategory("PCs")

AddData

Supported

ll_value = gr_1.FindSeries("Costs")

gr_1.AddData(ll_value, 12, 3)

AddSeries

Supported

li_value = gr_1.AddSeries("Costs")

CategoryCount

Supported

li_value = gr_1.CategoryCount()

CategoryName

Supported

ls_value = gr_1.CategoryName(5)

ClassName

Supported

ls_value= gr_1.ClassName(gd_double)

Clipboard

Supported

gr_1.Clipboard()

DataCount

Supported

ll_value = gr_1.DataCount("Costs")

DeleteCategory

Supported

gr_1.DeleteCategory(CategName)

DeleteData

Supported

gr_1.DeleteData(SeriesNbr, 7)

DeleteSeries

Supported

gr_1.DeleteSeries(ls_name)

Drag

Supported

gr_1.Drag(Begin!)

FindCategory

Supported

li_value=gr_1.FindCategory(sle_ctgry.Text)

FindSeries

Supported

li_value =gr_1.FindSeries(sle_series.Text)

GetData

Supported

data_value = gr_1.GetData(SeriesNbr, ItemNbr, xValue!)

GetDataPie​Explode

Supported

gr_1.GetDataPieExplode(series, datapoint, percentage)

Note: This function takes effect only in the pie graph. In other graphs the return value of GetDataPieExplode is -1.

GetDataStyle

Supported

ll_color = gr_emp_data.GetDataStyle(SeriesNbr, 6, Foreground!, color_nbr)

On the Web, the GetDataStyle function returns 1 if the specified data point and its series contain data, otherwise it returns -1. This is different from that in PowerBuilder.

GetDataValue

Supported

rtn = gr_1.GetDataValue(SeriesNbr, ItemNbr, data_value)

GetParent

Supported

luo_value = gr_1.GetParent()

GetSeriesStyle

Supported

gr_1.GetSeriesStyle(SeriesName, & line_style, line_width)

Hide

Supported

gr_1.Hide()

ImportClipboard

Supported

gr_1.ImportClipboard()

Notes:

  1. The importtype argument of this function is unsupported.

  2. When using this function, 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 the Web 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 (eg, 2006-08-01), on the Web the date data will be recognized as a string (2006), however in PowerBuilder, it will be recognized as a date data (2006-08-01).

ImportFile

Supported

gr_1.ImportFile("D:\EMPLOYEE.TXT", 2, 30, 3)

Note:

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

  2. The importtype argument of this function is unsupported.

  3. When using this function, 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 the Web 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 (eg, 2006-08-01), on the Web the date data will be recognized as a string (2006), however in PowerBuilder, it will be recognized as a date data (2006-08-01).

ImportString

Supported

gr_1.ImportString(ls_Text, 2, 30, 3)

Notes:

  1. The importtype argument of this function is unsupported.

  2. When using this function, 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 the Web 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 (eg, 2006-08-01), on the Web the date data will be recognized as a string (2006), however in PowerBuilder, it will be recognized as a date data (2006-08-01).

InsertCategory

Supported

gr_1.InsertCategory("Macs", CategoryNbr)

InsertData

Supported

gr_1.InsertData(SeriesNbr, CategoryNbr + 1, 1250)

Note: The data point will be inserted according to the sorting rules of the Category axis.

InsertSeries

Supported

gr_1.InsertSeries("Costs", SeriesNbr)

ModifyData

Supported

gr_1.ModifyData(SeriesNbr, & CategoryNbr, 1250)

Move

Supported

gr_1.Move(150, 200)

ObjectAtPointer

Supported

Object_type = gr_1.ObjectAtPointer(SeriesNbr, ItemNbr)

PointerX

Supported

li_value = gr_1.PointerX()

PointerY

Supported

li_value = gr_1.PointerY()

PostEvent

Supported

gr_1.PostEvent(Clicked!)

Print

Supported

gr_1.Print(1, "1-5", FALSE, TRUE)

Reset

Supported

gr_1.Reset(Series!)

ResetDataColors

Supported

gr_1.ResetDataColors(SeriesNbr, 10)

Resize

Supported

gr_1.Resize(100, 150)

SaveAs

Supported

gr_1.SaveAs()

SeriesCount

Supported

li_value = gr_1.SeriesCount()

SeriesName

Supported

ls_value = gr_1.SeriesName(5)

SetDataPieExplode

Supported

gr_1.SetDataPieExplode(series, datapoint, percentage)

SetDataStyle

Supported

gr_1.SetDataStyle("gr_depts" , SeriesNbr, 6, Background!, 0)

SetFocus

Supported

gr_1.SetFocus()

SetPosition

Supported

gr_1.SetPosition(ToTop!)

SetRedraw

Supported

gr_1.SetRedraw(FALSE)

SetSeriesStyle

Supported

gr_1.SetSeriesStyle("Costs", & SymbolPlus!)

Note: When using this function to set the overlay style of Graph DataWindow to "Scatter", it returns true and displays the DataWindow with all data points connected by lines. This is different from that in PowerBuilder.

Show

Supported

gr_1.Show()

TriggerEvent

Supported

gr_1.TriggerEvent(Clicked!)

TypeOf

Supported

gr_1.Typeof()

GetContextService

Unsupported

 

grAxis object

Properties for grAxis object

Table 138. 

Property

Support Level

Example Code

AutoScale

Supported

gr_1.Values.AutoScale = FALSE

Note: When this property is set to False, the maximum value for the axis cannot be smaller than the minimum value.

DataType

Supported

gr_1.Values.DataType = AdtDate!

Notes:

  1. On the Web, if the datatype of axis is set to AdtDateTime!, a graph can only display the data for one day.

  2. It is unsupported to dynamically modify the GraphType property, if the datatype of the axis will be changed after the modification.

DispAttr

Supported

 

DisplayEvery​NLabels

Supported

gr_1.Series.DisplayEveryNLabels = 10

DropLines

Supported

gr_1.Series.DropLines = Dash!

Frame

Supported

gr_1.Series.Frame = Dash!

Label

Supported

gr_1.Values.Label = 'Lawsuits per 1000'

LabelDispAttr

Supported

 

MajorDivisions

Supported

gr_1.Values.MajorDivisions = 10

MajorGridLine

Supported

gr_1.Value.MajorGridLine = Dash!

MajorTic

Supported

gr_1.Values.MajorTic = Straddle!

MaximumValue

Supported

gr_1.Values.DataType = AdtDouble!

gr_1.Values.MaximumValue = 500000.00

MaxValDateTime

Supported

gr_1.Values.DataType = AdtDate!

gr_1.Values.MaxValDateTime = 12/31/1999

MinimumValue

Supported

gr_1.Values.DataType = AdtDouble!

gr_1.Values.MinimumValue = 0.00

MinorDivisions

Supported

gr_1.Values.MinorDivisions = 10

MinorGridLine

Supported

gr_1.Value.MinorGridLine = Dot!

MinorTic

Supported

gr_1.Values.MinorTic = Outside!

MinValDateTime

Supported

gr_1.Values.DataType = AdtDate!

gr_1.Values.MinValDateTime = 01/31/1900

OriginLine

Supported

gr_1.Values.OriginLine = Dash!

PrimaryLine

Supported

gr_1.Values.PrimaryLine = Dash!

RoundTo

Supported

gr_1.Values.DataType = AdtDate!

gr_1.Values.RoundToUnit = RndMonths!

gr_1.Values.RoundTo = 6

RoundToUnit

Supported

gr_1.Values.DataType = AdtDate!

gr_1.Values.RoundToUnit = RndMonths!

gr_1.Values.RoundTo = 6

ScaleType

Supported

gr_1.Values.ScaleType=Log10!

Notes:

  1. Modifying the ScaleType property for an axis on the Web will affect only the involved axis. This may differ from PowerBuilder.

  2. Graphs on the Web will be displayed exactly as the settings of MajorDivisions, MinorDivisions, MaximunValue, and RoundTo. There is no displaying difference between the linear and logarithmic scaling.

ScaleValue

Supported

gr_1.Values.ScaleValue = Actual!

SecondaryLine

Supported

gr_1.Values.SecondaryLine = Dash!

ShadeBackEdge

Supported

gr_1.ShadeColor = RGB(240,250,150)

gr_1.Category.ShadeBackEdge = TRUE

ClassDefinition

Unsupported

 

Functions for grAxis object

Table 139. 

Function

Support Level

Example Code

ClassName

Supported

gr_1.value.ClassName()

GetParent

Supported

PowerObject lpo_returnvalue

lpo_returnvalue = gr_1.value.GetParent()

TypeOf

Supported

If gr_1.value.TypeOf() =grAxis! Then

ls_returnvalue = "grAxis!"

End If

GetContextService

Unsupported

 

grDispAttr object

Properties for grDispAttr object

Table 140. 

Property

Support Level

Example Code

Alignment

Supported

gr_1.Alignment = Center!

AutoSize

Supported

gr_1.TitleDispAttr.AutoSize = FALSE

BackColor

Supported

gr_1.BackColor = RGB(255, 255, 0)

DisplayExpression

Supported

gr_1.TitleDispAttr.DisplayExpression = 'title + " " + Today()'

Note: When specifying the display expression in the Display Expression field, please note that several items in the Columns box may be unsupported in certain situations:

  1. (For all graphs) The percentofcategory and The percentofgraph are unsupported.

  2. (For all graphs) The percentofseries is unsupported when the text object is set to Value Axis Text or Legend.

  3. The categorypercentofgraph and percentofseries are unsupported when the text object is set to Pie Graph Labels and there are multiple series.

  4. (For pie graph only) The percentofseries is unsupported when the text object is set to Legend.

Escapement

Supported

gr_1.Value.LabelDispAttr.Escapement = 900

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.

FaceName

Supported

gr_1.FaceName = ""

FillPattern

Supported

gr_1.FillPattern = Diamond!

FontCharSet

Supported

gr_1.FontCharSet = ANSI!

FontFamily

Supported

gr_1.FontFamily = Roman!

FontPitch

Supported

gr_1.FontPitch = Fixed!

Format

Supported

gr__1.Values.DispAttr.Format = "0.00"

Italic

Supported

gr_1.Italic = TRUE

TextColor

Supported

gr_1.Series.DispAttr.TextColor = RGB(0,0,255)

TextSize

Supported

gr_1.Values.LabelDispAttr.TextSize = 12

Underline

Supported

gr_1.Values.LabelDispAttr.Underline = TRUE

Weight

Supported

gr_1.Weight = 700

ClassDefinition

Unsupported

 

Functions for grDispAttr object

Table 141. 

Function

Support Level

Example Code

ClassName

Supported

gr_1.ClassName()

GetParent

Supported

luo_value = gr_1.GetParent()

TypeOf

Supported

If gr_1.TypeOf() = grDispAttr! Then

ls_returnvalue = "grDispAttr!"

End If

GetContextService

Unsupported

 

Inet object

Properties for Inet object

Table 142. 

Property

Support Level

Example Code

ClassDefinition

Unsupported

 

Events for Inet object

Table 143. 

Event

Support Level

Example Code

Constructor

Supported

Constructor

Destructor

Supported

Destructor


Functions for Inet object

Table 144. 

Function

Support Level

Example Code

ClassName

Supported

inet_1 = CREATE inet

li_classnm = inet_1.ClassName( )

GetParent

Supported

lpo_return = inet_1.GetParent()

GetURL

Supported

inet_1.GetURL( )

HyperLinkToURL

Supported

inet_1.HyperlinkToURL("http://www.appeon.com")

PostEvent

Supported

inet_1.PostEvent(Clicked!)

PostURL

Supported

li_return =Inet_1.PostURL()

Note: Appeon supports https address, though PB does not support it.

TriggerEvent

Supported

inet_1.TriggerEvent(Clicked!)

TypeOf

Supported

inet_1.Typeof()

GetContextService

Supported

GetContextService("Internet", inet_base)

inet_base.HyperlinkToURL("http://www.appeon.com")

Note: This function is supported only when the service name parameter is "Internet".


InternetResult object

Properties for InternetResult object

Table 145. 

Property

Support Level

Example Code

ClassDefinition

Unsupported

 

Events for InternetResult object

Table 146. 

Event

Support Level

Example Code

Constructor

Supported

Constructor

Destructor

Supported

Destructor


Functions for InternetResult object

Table 147. 

Function

Support Level

Example Code

ClassName

Supported

internetresult_1 = Create InternetResult

li_classnm= internetresult_1.ClassName()

GetParent

Supported

lpo_return = internetresult_1.GetParent()

InternetData

Supported

li_return = internetresult_1.InternetData(data)

InternetStatus

Supported

(Not used)

PostEvent

Supported

Internetresult_1.PostEvent(Clicked!)

TriggerEvent

Supported

Internetresult_1.TriggerEvent(Clicked!)

TypeOf

Supported

Internetresult_1.Typeof()

GetContextService

Unsupported

 

ListViewItem object

Properties for ListViewItem object

Table 148. 

Property

Support Level

Example Code

CutHighlighted

Supported

lvi_item1.CutHighlighted = True

Data

Supported

any_value = lvi_item1.Data

DropHighlighted

Supported

lvi_item1.DropHighlighted = True

HasFocus

Supported

lvi_item1.HasFocus = True

ItemX

Supported

 

ItemY

Supported

 

Label

Supported

ls_value = lvi_item1.Label

InPowerBuilder, if the string label is too long to display in one line, the string will display in multiple lines. However, in the Web application, the string will only display in one line.

OverlayPicture​Index

Supported

li_value = lvi_item1.OverlayPictureIndex

PictureIndex

Supported

li_value = lvi_item1.PictureIndex

Selected

Supported

lb_value = lvi_item1.Selected

StatePictureIndex

Supported

li_value = lvi_item1.StatePictureIndex

ClassDefinition

Unsupported

 

Functions for ListViewItem object

Table 149. 

Function

Support Level

Example Code

ClassName

Supported

ls_objectname = lvi_item1.ClassName()

TypeOf

Supported

IF lvi_item1.TypeOf() = ListViewItem! THEN

ls_returnvalue = "ListViewItem"

END IF

GetContextService

Unsupported

 

GetParent

Unsupported

 

mailFileDescription object

Properties for mailFileDescription object

Table 150. 

Property

Support Level

Example Code

FileType

Supported

mailFileDescription mAttach

mAttach.FileType = mailAttach!

Filename

Supported

mAttach.Filename = ls_filename

Pathname

Supported

mAttach.Pathname = ls_pathname

Position

Supported

mAttach.Position = ll_position

ClassDefinition

Unsupported

 

Functions for mailFileDescription object

Table 151. 

Function

Support Level

Example Code

ClassName

Supported

ls_classnm = mAttach.classname()

TypeOf

Supported

type_obj = mAttach.typeof()

GetContextService

Unsupported

 

GetParent

Unsupported

 

mailMessage object

Properties for mailMessage object

Table 152. 

Property

Support Level

Example Code

AttachmentFile[ ]

Supported

mMsg.AttachmentFile[1] = mAttach

ConversationID

Supported

ls_ID = mMsg.ConversationID

DateReceived

Supported

mMsg.DateReceived = ls_today

MessageSent

Supported

lb_sent = mMsg.MessageSent

MessageType

Supported

ls_type = mMsg.MessageType

NoteText

Supported

ls_note = mMsg.NoteText

ReceiptRequested

Supported

lb_return = mMsg.ReceiptRequested

Recipient[ ]

Supported

mailRecipient recip

mMsg.Recipient[1] = recip

Subject

Supported

mMsg.subject = ls_subject

Unread

Supported

mMsg.Unread = false

ClassDefinition

Unsupported

 

Functions for mailMessage object

Table 153. 

Function

Support Level

Example Code

ClassName

Supported

ls_classnm = mMsg.classname()

TypeOf

Supported

type_obj = mMsg.typeof()

GetContextService

Unsupported

 

GetParent

Unsupported

 

mailRecipient object

Properties for mailRecipient object

Table 154. 

Property

Support Level

Example Code

Address

Supported

mRecip.Address = ls_address

EntryID

Supported

ls_return = string(mRecip.EntryID)

Name

Supported

mRecip.Name = ls_name

RecipientType

Supported

mRecip.RecipientType = mailTo!

ClassDefinition

Unsupported

 

Functions for mailRecipient object

Table 155. 

Function

Support Level

Example Code

ClassName

Supported

ls_classnm = mRecip.classname()

TypeOf

Supported

type_obj = mRecip.typeof()

GetContextService

Unsupported

 

GetParent

Unsupported

 

mailSession object

Properties for mailSession object

Table 156. 

Property

Support Level

Example Code

MessageID[]

Supported

ls_message = mSes.MessageID[li_i]

SessionID

Supported

ll_sessionid = mSes.SessionID

ClassDefinition

Unsupported

 

Events for mailSession object

Table 157. 

Event

Support Level

Example Code

Constructor

Supported

Constructor

Destructor

Supported

Destructor


Functions for mailSession object

Table 158. 

Function

Support Level

Example Code

ClassName

Supported

ls_classnm = mSes.classname()

GetParent

Supported

lobj_parent = mSes.GetParent

mailAddress

Supported

mRet = mSes.mailAddress()

mailDelete​Message

Supported

mRet = mSes.mailDeleteMessage(sID)

mailGetMessages

Supported

mRet = mSes.mailGetMessages()

mailHandle

Supported

mHandle = mSes.mailHandle()

mailLogoff

Supported

mRet = mSes.mailLogoff()

mailLogon

Supported

mRet = mSes.mailLogon ()

mailReadMessage

Supported

mRet = mSes.mailReadMessage(sMessageID, mMsg , mailEntireMessage!, TRUE)

mailRecipient​Details

Supported

mRet = mSes.mailRecipientDetails(mMsg.Recipient[1],TRUE)

mailResolve​Recipient

Supported

mRet = mSes.mailResolveRecipient(mRecip,true)

mailSaveMessage

Supported

mRet = mSes.mailSaveMessage(mMsg.ConversationID, mMsg)

mailSend

Supported

mRet = mSes.mailsend(mMsg)

PostEvent

Supported

lb_return = mSes.PostEvent("ue_user")

TriggerEvent

Supported

lb_return = mSes.TriggerEvent("ue_user")

TypeOf

Supported

type_obj = mSes.typeof()

GetContextService

Unsupported

 

MDIClient object

Important Requirements

Multiple MDI windows are supported.

Defining the size of the client area in an MDI window is supported.

If there are multiple MDI frames, the second frame window of the Web application will be loaded at a much slower speed up to four times slower than the first one. If the first MDI is closed, the second one will not function.

When the MDI frame is closed in an Appeon-deployed application, the Web browser will also close automatically.

Properties for MDIClient object

Table 159. 

Property

Support Level

Example Code

BackColor

Supported

w_main.mdi_1.BackColor = ll_value

Height

Supported

w_main.mdi_1.Height = li_value

MicroHelpHeight

Supported

li_return = w_main.mdi_1.MicroHelpHeight

Tag

Supported

w_main.mdi_1.Tag = ls_value

Width

Supported

w_main.mdi_1.Width = li_value

X

Supported

w_main.mdi_1.X = li_value

Y

Supported

w_main.mdi_1.Y = li_value

BringToTop

Unsupported

 

ClassDefinition

Unsupported

 

Visible

Supported

 

Functions for MDIClient object

Table 160. 

Function

Support Level

Example Code

ClassName

Supported

ls_classname = w_main.mdi_1.Classname()

GetParent

Supported

PowerObject lpo_returnvalue

lpo_returnvalue = this.GetParent()

Hide

Supported

w_main.Hide()

Move

Supported

w_main.Move(150,200)

Resize

Supported

w_main.Resize(100, 150)

SetRedraw

Supported

w_main.SetRedraw(FALSE)

Show

Supported

m_main.Show()

TypeOf

Supported

ls_type = w_main.mdi_1.TypeOf()

GetContextService

Unsupported

 

Menu object

Important Requirements

  • Menus can be dynamically created (for example, using the CREATE statement).

  • When a menu is dynamically created, it is unsupported to create multiple items to the menu at one time.

  • Use of Main menu should be limited to no more than five layers of submenus for a single menu item.

  • More levels of dropdown menus under a menu bar item are supported.

  • Appeon supports user-defined menu events and functions.

  • For more information on menu object, refer to: Menu Features and Toolbar Features.

Menu features

Supported

  • Menu object may be implemented with the following functionalities:

    1. Modifying menu items based on user rights using the enable and visible properties.

    2. User-defined functions in menu object.

  • It is supported to have a menu object as a structure variable, or define a structure/declare a structure instance in a menu object.

  • It is supported to declare a menu type array.

  • It is supported to qualify the item of a child menu with the class name of the parent menu.

    For example:

    m_city is the menu for the window w_citysheet, and is inherited from m_main. m_file is an item of the menu m_city.

    The following two lines of code have the same effect on the Web:

    m_main.m_file.enabled = FALSE
    m_city.m_file.enabled = FALSE
    
  • It is supported to declare a menu variable, assign value to it, and pass the variable as argument.

    For example:

    menu lm_onemenu
    lm_ onemenu = create menu
    lm_ onemenu.text = "Open a window" //or
    lm_ onemenu = m_main.m_file //or
    lm_ onemenu = m_main.Item[1].Item[1]
    
  • A window control can use the ChangeMenu function to dynamically change the menu. See the ChangeMenu function for Window control.

  • Switching between different menus is allowed. However, only one menu can be displayed at one time. For example, the MDI window menu can be dynamically refreshed when a sheet is opened or closed.

  • Append the names of open sheets (window list) to a menu item.

  • Using the UpArrow/DownArrow/LeftArrow/RightArrow to change the currently selected menu item is supported.

  • Shortcut keys for menu items are supported.

Unsupported

  • In PowerBuilder, the menu items always show in front of main window or popup window. In Web applications, the menu items may get hidden behind a main window or a popup window.

  • Different from PowerBuilder as follows: In the case of multiple Web windows loading the same menu, when a window (window A) accesses the menu object, the menu object accessed is not the menu in the window A, but the menu in the window that is most recently opened.

  • It is not supported to access the menu of the window that currently does not have focus.

Toolbar features

Supported

  • The toolbar item synchronizes with the relevant menu item. If the property of the menu item changes, the property of the toolbar item changes accordingly.

  • Multiple toolbars are supported.

  • Multiple toolbars can be displayed at the same time, but docked toolbar or toolbar toggle are not supported.

  • Toolbar can only be displayed in the MDI and MDIHelp windows.

Unsupported

  • In Web applications, the toolbars are always placed directly below the menu. The Web toolbar cannot be dragged around or placed at any other place.

  • In PowerBuilder, if the user right mouse clicks over a toolbar, a popup menu is displayed with the available options, for example: Left, Right, Floating, Show Text, Show PowerTips. The popup menu will not display in Web applications. The toolbar item cannot show text but can show PowerTips.

  • Clicking the toolbar item will not trigger the Selected event for Menu object.

  • If the ShiftToRight property is set to TRUE, menu objects may shift to right and toolbar items will automatically adjust its places according to the menu changes in PowerBuilder. However, toolbar items will not automatically adjust its places on the Web.

Properties for Menu object

Table 161. 

Property

Support Level

Example Code

Checked

Supported

m_function.m_testitemforfunction.Checked = lb_value

Default

Supported

m_function.m_testitemforfunction.Default = TRUE

Enabled

Supported

m_function.m_testitemforfunction.Enabled = lb_value

Item [ ]

Supported

Menu lmenu_item[]

lmenu_item =m_menu.Item[]

Support using Item[] in different ways:

lm_ onemenu = m_main.Item[1].Item[1]

m_main.Item[1].Item[1].text = "open a Window"

m_main.Item[1].Item[1].triggerevent(clicked)

Dynamically adding menu items with Item[] is supported.

MicroHelp

Supported

m_function.m_testitemforfunction.MicroHelp = ls_value

ParentWindow

Supported

w_value = m_function.Parentwindow

ShiftToRight

Supported

m_function.m_testitemforfunction.ShiftToRight = true

Shortcut

Supported

 

Tag

Supported

m_function.m_testitemforfunction.Tag = ls_value

Text

Supported

m_function.m_testitemforfunction.Text = ls_value

ToolbarItemBar​Index

Supported

m_function.m_testitemforfunction.ToolbarItemBarIndex = li_value

Note: If the property ToolbarItemBarIndex is set to 0, the toolbar does not display in PowerBuilder but displays on the Web.

ToolbarItemDown

Supported

m_function.m_testitemforfunction.ToolbarItemDown = true

ToolbarItemDown Name

Supported

m_function.m_testitemforfunction.ToolbarItemDownName = ls_value

ToolbarItemName

Supported

m_function.m_testitemforfunction.ToolbarItemName = ls_value

ToolbarItemOrder

Supported

m_function.m_testitemforfunction.ToolbarItemOrder = li_value

ToolbarItemSpace

Supported

m_function.m_testitemforfunction.ToolBarItemSpace = 5

ToolbarItemText

Supported

m_function.m_testitemforfunction.ToolbarItemText = ls_value

ToolbarItemVisible

Supported

m_function.m_testitemforfunction.ToolbarItemVisible = lb_value

Visible

Supported

m_function.m_testitemforfunction.Visible = lb_value

ClassDefinition

Unsupported

 

MenuItemType

Unsupported

 

MergeOption

Unsupported

 

Events for Menu object

Table 162. 

Event

Support Level

Example Code

Clicked

Supported

Note: The Clicked event cannot be triggered for a menu item that has a submenu.

Selected

Supported

 

Help

Unsupported

 

Functions for Menu object

Table 163. 

Function

Support Level

Example Code

Check

Supported

ll_returnvalue = m_function.m_testitemforfunction.Check()

ClassName

Supported

ls_returnvalue = m_function.m_testitemforfunction.ClassName()

Disable

Supported

ll_returnvalue = m_function.m_testitemforfunction.Disable()

Enable

Supported

ll_returnvalue = m_function.m_testitemforfunction.Enable()

GetParent

Supported

lobj_returnvalue = m_function.GetParent()

Hide

Supported

ll_returnvalue = m_function.m_testitemforfunction.Hide()

PopMenu

Supported

ll_returnvalue = m_function.m_testitemforfunction.PopMenu(xlocation, ylocation)

PostEvent

Supported

ll_returnvalue = m_function.m_testitemforfunction.PostEvent(event)

Show

Supported

ll_returnvalue = m_function.m_testitemforfunction.Show()

TriggerEvent

Supported

ll_returnvalue = m_function.m_testitemforfunction.TriggerEvent(event)

TypeOf

Supported

If m_function.m_testitemforfunction.TypeOf() = menu! Then

ls_returnvalue = "menu"

end if

Uncheck

Supported

ll_returnvalue = m_function.m_testitemforfunction.Uncheck()

GetContextService

Unsupported

 

MenuCascade object

Important requirements

  • It is unsupported to place a cascading menu in another cascading menu.

  • When you extend a cascading menu, the first dropdown item automatically get focus on the Web. Pressing the blank key can trigger the Click event of the item with focus and the focus can be shifted between items if you pressing the Up and Down arrow keys.

  • Changes to a Web menu will be updated automatically without calling the Hide and Show functions for the Menu.

Properties for MenuCascade object

Table 164. 

Property

Support Level

Example Code

Checked

Supported

m_function.m_testitemforfunction.Checked = lb_value

Column

Supported

m_menu.Columns = li_count

CurrentItem

Supported

 

Default

Supported

m_menu.Default = TRUE

DropDown

Supported

m_menu.DropDown = False

Enabled

Supported

m_function.m_testitemforfunction.Enabled = lb_value

Item [ ]

Supported

lmenu_item = m_menu.Item[ ]

MicroHelp

Supported

m_function.m_testitemforfunction.MicroHelp = ls_value

ParentWindow

Supported

w_value = m_function.Parentwindow

ShiftToRignt

Supported

m_menu.ShiftToRight = True

Shortcut

Supported

li_return = m_menu.Shortcut

Tag

Supported

m_function.m_testitemforfunction.Tag = ls_value

Text

Supported

m_function.m_testitemforfunction.Text = ls_value

ToolbarItemDown

Supported

m_function.m_testitemforfunction.ToolbarItemDown = lb_flag

ToolbarItemDown Name

Supported

m_function.m_testitemforfunction.ToolbarItemDownName = ls_value

ToolbarItemBar​Index

Supported

m_function.m_testitemforfunction.ToolbarItemBarIndex = li_value

Note: If the property ToolbarItemBarIndex is set to 0, the toolbar does not display in PowerBuilder but displays on the Web.

ToolbarItemName

Supported

m_function.m_testitemforfunction.ToolbarItemName = ls_value

ToolbarItemOrder

Supported

m_function.m_testitemforfunction.ToolbarItemOrder = li_value

Note: the value of ToolbarItemOrder cannot be a negative number.

ToolbarItemText

Supported

m_function.m_testitemforfunction.ToolbarItemText = ls_value

ToolbarItemVisible

Supported

m_function.m_testitemforfunction.ToolbarItemVisible = lb_value

Visible

Supported

m_function.m_testitemforfunction.Visible = lb_value

ClassDefinition

Unsupported

 

MenuItemType

Unsupported

 

MergeOption

Unsupported

 

Events for MenuCascade object

Table 165. 

Event

Support Level

Example Code

Clicked

Supported

Clicked

Note: The Clicked event cannot be triggered for a menu item that has a submenu.

Selected

Supported

Selected

Help

Unsupported

 

Functions for MenuCascade object

Table 166. 

Function

Support Level

Example Code

Check

Supported

ll_returnvalue = m_function.m_testitemforfunction.Check()

ClassName

Supported

ls_returnvalue = m_function.m_testitemforfunction.ClassName()

Disable

Supported

ll_returnvalue = m_function.m_testitemforfunction.Disable()

Enable

Supported

ll_returnvalue = m_function.m_testitemforfunction.Enable()

GetParent

Supported

lobj_returnvalue = m_function.GetParent()

Hide

Supported

ll_returnvalue = m_function.m_testitemforfunction.Hide()

PopMenu

Supported

ll_returnvalue = m_function.m_testitemforfunction.PopMenu(xlocation, ylocation)

PostEvent

Supported

ll_returnvalue = m_function.m_testitemforfunction.PostEvent(event)

Show

Supported

ll_returnvalue = m_function.m_testitemforfunction.Show()

TriggerEvent

Supported

ll_returnvalue = m_function.m_testitemforfunction.TriggerEvent(event)

TypeOf

Supported

If m_function.m_testitemforfunction.TypeOf() = menu! Then

ls_returnvalue = "menu"

end if

Uncheck

Supported

ll_returnvalue = m_function.m_testitemforfunction.Uncheck()

GetContextService

Unsupported

 

Message object

Important Requirements

  • Both the system message and the user-defined message are supported.

Properties for Message object

Table 167. 

Property

Support Level

Example Code

DoubleParm

Supported

OpenWithParm(w_1, ld_value)

ld_value = Message.DoubleParm

LongParm

Supported

ls_value = Message.LongParm

PowerObjectParm

Supported

OpenWithParm(w_1, s_value)

ls_value = Message.PowerObjectParm

Processed

Supported

 

StringParm

Supported

OpenWithParm(w_1, ls_value)

ls_value = Message.StringParm

WordParm

Supported

 

ClassDefinition

Unsupported

 

Handle

Unsupported

 

Number

Unsupported

 

ReturnValue

Unsupported

 

Events for Message object

Table 168. 

Event

Support Level

Example Code

Constructor

Supported

 

Destructor

Supported

 

Functions for Message object

Table 169. 

Function

Support Level

Example Code

ClassName

Supported

string varname

varname = ClassName(gd_double)

GetParent

Supported

lobj_parent = cb_1.GetParent()

PostEvent

Supported

cb_1.PostEvent(Clicked!)

TriggerEvent

Supported

cb_1.TriggerEvent(Clicked!)

TypeOf

Supported

dw_1.Typeof()

GetContextService

Unsupported

 

NonVisualObject object

Properties for NonVisualObject object

Table 170. 

Property

Support Level

Example Code

ClassDefinition

Unsupported

 

Events for NonVisualObject object

Table 171. 

Event

Support Level

Example Code

Constructor

Supported

Constructor

Destructor

Supported

Destructor


Functions for NonVisualObject object

Table 172. 

Function

Support Level

Example Code

ClassName

Supported

nvo_test.classname()

GetParent

Supported

lobj_parent = nvo_test.GetParent()

PostEvent

Supported

nvo_test.PostEvent(Constructor!)

TriggerEvent

Supported

nvo_test.TriggerEvent(Constructor!)

TypeOf

Supported

If nvo_test.typeof()=nonvisualobject! Then

ls_value='nonvisualobject!'

End If

GetContextService

Unsupported

 

OLEObject object

Unsupported

The shortcut key for OCX is unsupported.

It is unsupported to have blob, DataTime, Date, or Time parameters in functions of OLEObject object.

The datatype of the property value cannot be Datetime, Date, or Time.

Properties for OLEObject object

Table 173. 

Property

Support Level

Example Code

ClassDefinition

Unsupported

 

Handle

Unsupported

 

Events for OLEObject object

Table 174. 

Event

Support Level

Example Code

Constructor

Supported

Constructor

Destructor

Supported

Destructor

Error

Unsupported

 

ExternalException

Unsupported

 

Functions for OLEObject object

Table 175. 

Function

Support Level

Example Code

ClassName

Supported

ls_return = ole_1.ClassName()

ConnectToNew​Object

Supported

OLEObject myoleobject

myoleobject = CREATE OLEObject

li_return = myoleobject.ConnectToNewObject( "excel.application")

ConnectToObject

Supported

OLEObject myoleobject

myoleobject = CREATE OLEObject

li_return = myoleobject.ConnectToObject("c:\excel\expense.xls")

DisconnectObject

Supported

li_return = myoleobject.DisconnectObject()

GetAutomation​NativePointer

Supported

UnsignedLong lul_oleptr

li_return = ocx_spell.GetNativePointer(lul_oleptr)

IsAlive

Supported

IF ole_1.IsAlive() THEN return

PostEvent

Supported

ole_1.PostEvent("Error")

Release​AutomationNative​Pointer

Supported

li_return = ocx_spell.ReleaseNativePointer(lul_oleptr)

SetAutomation​Pointer

Supported

li_return = oleChild.SetAutomationPointer(myoleobject)

TriggerEvent

Supported

li_return = ole_1.TriggerEvent("Error")

TypeOf

Supported

 

ConnectToNew​RemoteObject

Unsupported

 

ConnectTo​RemoteObject

Unsupported

 

GetContextService

Unsupported

 

GetParent

Supported

 

SetAutomation​Locale

Unsupported

 

SetAutomation​Timeout

Unsupported

 

OLEStorage object

Properties for OLEStorage object

Table 176. 

Property

Support Level

Example Code

ClassDefinition

Unsupported

 

DocumentName

Unsupported

 


Events for OLEStorage object

Table 177. 

Event

Support Level

Example Code

Constructor

Supported

Constructor

Destructor

Supported

Destructor


Functions for OLEStorage object

Table 178. 

Function

Support Level

Example Code

ClassName

Supported

 

Clear

Supported

 

Close

Supported

 

GetContextService

Supported

 

GetParent

Supported

 

MemberDelete

Unsupported

 

MemberExists

Supported

 

MemberRename

Supported

 

Open

Supported

 

PostEvent

Supported

 

Save

Supported

 

SaveAs

Unsupported

 

TriggerEvent

Supported

 

TypeOf

Supported

 

OLEStream object

Properties for OLEStream object

Table 179. 

Property

Support Level

Example Code

ClassDefinition

Unsupported

 

Name

Unsupported

 

Storage

Unsupported

 


Events for OLEStream object

Table 180. 

Event

Support Level

Example Code

Constructor

Supported

Constructor

Destructor

Supported

Destructor


Functions for OLEStream object

Table 181. 

Function

Support Level

Example Code

ClassName

Supported

 

Close

Supported

 

GetContextService

Supported

 

GetParent

Supported

 

Length

Supported

The return value in PowerServer Web is as follows (which is different from PowerBuilder):

>=0 -- The length of stream.

-1 -- Stream is not opened.

-9 -- Other errors.

Open

Supported

 

PostEvent

Supported

 

Read

Supported

 

Seek

Supported

 

TriggerEvent

Supported

 

TypeOf

Supported

 

Write

Supported

 

Timing object

Properties for Timing object

Table 182. 

Property

Support Level

Example Code

Interval

Supported

ld_return = timing_1.interval

Running

Supported

lb_return = timing_1.running

ClassDefinition

Unsupported

 

Events for Timing object

Table 183. 

Event

Support Level

Example Code

Constructor

Supported

Constructor

Destructor

Supported

Destructor

Timer

Supported

Timer(10, w_main)


Functions for Timing object

Table 184. 

Function

Support Level

Example Code

ClassName

Supported

timing_1 = CREATE uo_timer

ls_classnm = timing_1.ClassName( )

GetParent

Supported

lobj_parent_name = timing_1.GetParent()

PostEvent

Supported

timing_1.PostEvent(Clicked!)

Start

Supported

timing_1.Start(60)

Stop

Supported

timing_1.Stop()

TriggerEvent

Supported

timing_1.TriggerEvent(Clicked!)

TypeOf

Supported

timing_1.Typeof()

GetContextService

Unsupported

 

Transaction object

Important Requirements

The Transaction object can either be global or local. The instance transaction object is unsupported.

The user-defined Transaction object is supported.

The type of SQLCA can be transaction or transaction user object. It is supported if the user defines a transaction user object (for example, u_trans) and sets the type of SQLCA to the transaction user object (for example, u_trans).

An application can have multiple Transactions Objects, and the Transaction Objects can be connected to different type of databases.

The specification of isolation level for a database profile in PowerBuilder is not supported.

Properties for Transaction object

Appeon ignores the dynamic property settings for the data source and Transaction Object except for the AutoCommit property.

Table 185. 

Property

Support Level

Example Code

AutoCommit

Supported

sqlca.AutoCommit = lb_value

Notes:

  1. If the database server is Oracle and the driver is native driver, the AutoCommit setting is always interpreted as FALSE.

  2. The AutoCommit property is the only property that may be dynamically modified.

Database

Supported

ls_value = sqlca.Database

DBMS

Supported

ls_value = sqlca.DBMS

Appeon extends this property so it can be used to specify the database type of the data source that is used by the CacheName parameter. For values representing the different database types, refer to Table 21, “Setting the DBMS property based on the database type” in PowerServer Configuration Guide for .NET or Table 36, “Setting the DBMS property based on the database type” in PowerServer Configuration Guide for J2EE.

DBPass

Supported

 

DBParm

Supported

  • The ConnectString parameter will be ignored when executed in the mobile or Web application, because the database connection for the mobile or Web application (called data source) is configured separately in Appeon or the application server. For details, refer to Database Connection Setup in PowerServer Configuration Guide for .NET or Database Connection Setup in PowerServer Configuration Guide for J2EE.

  • The CacheName parameter is enhanced by Appeon, so it is working differently when executed in the mobile or Web application than when executed in the PB application.

    CacheName is optional depending on the specific scenario of the database connection used in the mobile or Web application. If one transaction object needs to connect with more than one database, then CacheName can be used and set to the name of the data source (as shown in the code example below); if one transaction object connects with only one database, then CacheName might not be necessary, as you can statically map the transaction object with the data source in AEM.

    For example,

    sqlca.DBParm = "CacheName='ASADataSource1'"

    Using CacheName enables the mobile or Web application to dynamically change the data source at runtime, rather than statically mapping the transaction object with the data source in AEM before the application is run. For more information, refer to the section called “Setting up transaction object to data source mapping” in PowerServer Configuration Guide for .NET or the section called “Setting up transaction object to data source mapping” in PowerServer Configuration Guide for J2EE.

LogID

Supported

ls_value = sqlca.LogID

LogPass

Supported

ls_value = sqlca.LogPass

ServerName

Supported

ls_value = sqlca.ServerName

SQLCode

Supported

ll_value = sqlca.SQLCode

The returned value of SQLCode in Appeon:

<0 – Error; the statement failed. This is different from PowerBuilder where -1 will be returned, while in Appeon, it could be any negative number when there is an error. Therefore, it is recommended to use <0 as the evaluation value for errors in both PowerBuilder and Appeon.

0 – Success.

100 – No result.

SQLDBCode

Supported

ll_value = sqlca.SQLDBCode

Notes:

  1. In PowerBuilder, if sqlca.SQLCode=100, sqlca.SQLDBCode = 3. In Appeon, when sqlca.SQLCode=100, sqlca.SQLDBCode = 0.

  2. In the Web application, SQLDBCode returns a different value from PowerBuilder. It is recommended not to use SQLDBCode in statements such as IF…ELSE.

SQLErrText

Supported

ls_value = sqlca.SQLErrText

SQLNRows

Supported

ll_value = sqlca.SqlNRows

UserID

Supported

ls_value = sqlca.UserID

ClassDefinition

Unsupported

 

Lock

Unsupported

 

SQLReturnData

Unsupported

 

Events for Transaction object

Table 186. 

Event

Support Level

Example Code

Constructor

Supported

Constructor

Destructor

Supported

Destructor

DBNotification

Unsupported

 

DBError

Unsupported

 

SQLPreview

Unsupported

 

Functions for Transaction object

Table 187. 

Function

Support Level

Example Code

ClassName

Supported

ls_returnvalue = sqlca.ClassName()

TypeOf

Supported

if this.TypeOf() = transaction! Then

Is_returnvalue = "transaction!"

end if

DBHandle

Supported

 

PostEvent

Supported

 

SyntaxFromSQL

Supported

ls_dw_syntax = SQLCA.SyntaxFromSQL(ls_sql_syntax, ls_style, ls_dw_err)

Notes:

  1. The following syntax is unsupported:

    ls_dw_syntax = SyntaxFromSQL(sqlca, ls_sql_syntax, ls_style, ls_dw_err)

  2. The data type of computed columns in SyntaxFromSQL cannot be the Appeon unsupported data type.

  3. The length of return value on the Web is different from PowerBuilder

  4. The return value of the SyntaxFromSQL function on the Web contains a column name for each column although it is not in PowerBuilder.

  5. The function cannot generate correct source code for TreeView DataWindow.

TriggerEvent

Supported

 

GetContextService

Unsupported

 

GetParent

Supported

 

TreeViewItem object

Properties for TreeViewItem object

Table 188. 

Property

Support Level

Example Code

Bold

Supported

tv_treeviewitem.Bold = TRUE

Children

Supported

tv_treeviewitem.Children = FALSE

Data

Supported

tv_treeviewitem.Data = sle_prop.text

Expanded

Supported

tv_treeviewitem.Expanded = TRUE

Note: the property is supported but is read-only.

ExpandedOnce

Supported

tv_treeviewitem.ExpandedOnce = TRUE

Note: the property is supported but is read-only.

HasFocus

Supported

tv_treeviewitem.HasFocus = TRUE

Note: the property is supported but is read-only.

ItemHandle

Supported

tv_treeviewitem.Itemhandle = long(sle_prop.text)

Note: This property is supported but is read-only.

OverlayPicture​Index

Supported

l_tvi.OverlayPictureIndex = 2

Label

Supported

tv_treeviewitem.Label = sle_prop.text

Level

Supported

tv_treeviewitem.Level = long(sle_prop.text)

PictureIndex

Supported

tv_treeviewitem.PictureIndex = long(sle_prop.text)

SelectedPictureIndex

Supported

tv_treeviewitem.SelectedPictureIndex = long(sle_prop.text)

Selected

Supported

lb_value = tv_treeviewitem.Selected

StatePicture​Index

Supported

li_value = tv_treeviewitem.StatePictureIndex

ClassDefinition

Unsupported

 

CutHighLighted

Unsupported

 

DropHighLighted

Unsupported

 

Functions for TreeViewItem object

Table 189. 

Function

Support Level

Example Code

ClassName

Supported

ls_returnvalue = tv_treeviewitem.ClassName()

TypeOf

Supported

If ltvi_1.TypeOf() = TreeViewItem! Then

ls_returnvalue = "TreeViewItem!"

End If

GetContextService

Unsupported

 

GetParent

Unsupported

 

UserObject object

Important Requirements

The UserObject object can be dynamically created (for example, by using the CREATE statement).

Properties for UserObject object

Table 190. 

Property

Support Level

Example Code

BackColor

Supported

uo_test.BackColor = ll_value

Note: transparent value is unsupported.

Border

Supported

uo_test.Border = lb_value

BorderStyle

Supported

uo_test.BorderStyle = StyleBox!

uo_test.BorderStyle = StyleLowered!

uo_test.BorderStyle = StyleRaised!

Note: StyleShadowBox! is unsupported.

ClassName

Supported

ls_value = uo_test.ClassName

BringToTop

Supported

uo_test.BringToTop = TRUE

Control[]

Supported

WindowObject lobj_control[]

lobj_control[] = uo_test.control[]

DragAuto

Supported

uo_test.DragAuto=TRUE

DragIcon

Supported

uo_test.DragIcon='c:\archive\arrow.ico'

Enabled

Supported

uo_test.Enabled = TRUE

Height

Supported

uo_test.Height = 300

HScrollBar

Supported

uo_1.HScrollBar = false

Pointer

Supported

uo_test.Pointer='Help!'

uo_test.Pointer='d:\archive\IBEAM.BMP.cur'

PictureName

Supported

uo_test.PictureName = "c:\pictures\pb1.bmp"

PowerTipText

Supported

uo_test.PowerTipText="UserObject PowerTip"

TabBackColor

Supported

uo_tab.tab_page1.TabBackColor = RGB(0,0,255)

TabOrder

Supported

uo_test.TabOrder = li_value

TabTextColor

Supported

uo_tab.tab_page1.TabTextColor =5566

Tag

Supported

uo_test.Tag = ls_value

Text

Supported

uo_test.Text = ls_value

Visible

Supported

uo_test.Visible = lb_value

VScrollBar

Supported

uo_test.VScrollBar = lb_value

Width

Supported

uo_test.Width = li_value

X

Supported

uo_test.X = li_value

Y

Supported

uo_test.Y = li_value

ClassDefinition

Unsupported

 

ColumnsPerPage

Unsupported

 

LibraryName

Unsupported

 

LinesPerPage

Unsupported

 

ObjectType

Unsupported

 

PictureMaskColor

Unsupported

 

Style

Unsupported

 

Transparency

Unsupported

 

UnitsPerColumn

Unsupported

 

UnitsPerLine

Unsupported

 

Events for UserObject object

Table 191. 

Event

Support Level

Example Code

Constructor

Supported

Destructor

Supported

DragDrop

Supported

DragEnter

Supported

DragLeave

Supported

DragWithin

Unsupported

RButtonDown

Supported

Help

Unsupported

 

Other

Unsupported

 

Functions for UserObject object

Table 192. 

Function

Support Level

Example Code

ClassName

Supported

uo_test.classname()

Drag

Supported

uo_test.Drag(Begin!)

GetParent

Supported

lobj_parent_name = this.GetParent()

Hide

Supported

uo_test.Hide()

Move

Supported

uo_test.Move(x1,y1)

OpenUserObject

Supported

Note: Using Post function to call the OpenUserObject function is unsupported, for example, this.post openuserobject (icbx_uo,100,100) is unsupported.

PointerX

Supported

uo_test.PointerX()

PointerY

Supported

uo_test.PointerY()

PostEvent

Supported

uo_test.PostEvent(Clicked!)

Resize

Supported

uo_test.Resize(x1,y1)

SetFocus

Supported

uo_test.SetFocus()

SetPosition

Supported

uo_test.SetPosition(ToTop!)

uo_two.SetPosition(Behind!, uo_three)

SetRedraw

Supported

li_return= uo_test.SetRedraw(TRUE)

Show

Supported

uo_test.Show()

TriggerEvent

Supported

uo_test.TriggerEvent(Clicked!)

TypeOf

Supported

If uo_test.typeof()=CheckBox! Then

ls_value='CheckBox!'

End If

AddItem

Unsupported

 

CreatePage

Unsupported

 

DeleteItem

Unsupported

 

GetContextService

Unsupported

 

InsertItem

Unsupported

 

OpenUserObjectWithParm

Unsupported

 

PageCreated

Unsupported

 

Print

Unsupported

 

WSConnection object

Properties for WSConnection object

Table 193. 

Property

Support Level

Example Code

Endpoint

Supported

Authentication​Mode

Unsupported

 

ClassDefinition

Unsupported

 

ClientCertificate​File

Unsupported

 

Password

Unsupported

 

ProxyServerHost​Name

Unsupported

 

ProxyServer​Password

Unsupported

 

ProxyServerPort

Unsupported

 

ProxyServer​UserName

Unsupported

 

Timeout

Unsupported

 

UserDomain

Unsupported

 

UserName

Unsupported

 

UseWindows​Integrated​Authentication

Unsupported

 

Events for WSConnection object

Table 194. 

Event

Support Level

Example Code

Constructor

Supported

Note: Activate and Deactivate events are unsupported for dialogue boxes.

Destructor

Supported

Clicked


Functions for WSConnection object

Table 195. 

Function

Support Level

Example Code

ClassName

Supported

w_mdi.ArrangeSheets(arrangetype)

GetParent

Supported

Parent.ChangeMenu(m_test_menu2)

PostEvent

Supported

ls_value = w_test.ClassName()

TriggerEvent

Supported

w_test.CloseChannel()

TypeOf

Supported

w_test.CloseUserObject()

GetContextService

Unsupported