Connection Information

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Connection Type

DataWindow Reference – PB Docs 2021 – PowerBuilder Library

DataWindow Reference – PB Docs 2021

DataWindow Reference

Appeon PowerBuilder® 2021

FOR WINDOWS

DOCUMENT ID: DC37783-01-1900-01

LAST REVISED: January 27, 2022

Copyright © Appeon. All rights reserved.

This publication pertains to Appeon software and to any subsequent
release until otherwise indicated in new editions or technical notes.
Information in this document is subject to change without notice. The
software described herein is furnished under a license agreement, and it
may be used or copied only in accordance with the terms of that
agreement.

Upgrades are provided only at regularly scheduled software release
dates. No part of this publication may be reproduced, transmitted, or
translated in any form or by any means, electronic, mechanical, manual,
optical, or otherwise, without the prior written permission of Appeon
Inc.

Appeon and other Appeon products and services mentioned herein as
well as their respective logos are trademarks or registered trademarks
of Appeon Inc.

SAP and other SAP products and services mentioned herein as well
as their respective logos are trademarks or registered trademarks of SAP
and SAP affiliate company.

Java and all Java-based marks are trademarks or registered
trademarks of Oracle and/or its affiliates in the U.S. and other
countries.

Unicode and the Unicode Logo are registered trademarks of Unicode,
Inc.

All other company and product names mentioned may be trademarks of
the respective companies with which they are associated.

Use, duplication, or disclosure by the government is subject to
the restrictions set forth in subparagraph (c)(1)(ii) of DFARS
52.227-7013 for the DOD and as set forth in FAR 52.227-19(a)-(d) for
civilian agencies.

Appeon Inc., 1/F, Shell Industrial Building, 12 Lee Chung
Street, Chai Wan District, Hong Kong.

Contents

DataWindow
Operators and Expressions
Where you
use DataWindow expressions
Operators used in DataWindow
expressions
Operator
precedence in DataWindow expressions
Evaluating
DataWindow expressions in scripts
Evaluating
DataWindow expressions in the Describe function
Evaluating
conditional DataWindow expressions with current data
DataWindow Expression Functions
Using DataWindow expression functions
Decimal support in DataWindow expressions
Four examples
Alphabetical list of DataWindow expression functions
DataWindow Object Properties
Overview of DataWindow object properties
Controls in a DataWindow and their properties
Alphabetical list of DataWindow object properties
Accessing Data in Code
Accessing data and properties in
DataWindow programming environments
Techniques
for accessing data
Syntaxes for
DataWindow data expressions
Accessing DataWindow Object Properties in Code
About
properties of the DataWindow object and its controls
PowerBuilder: Modify and Describe methods for properties
PowerBuilder:
DataWindow property expressions
JavaScript:
Modify and Describe methods for properties
DataWindow
Constants
About
DataWindow constants
Alphabetical list of DataWindow
constants
AccessibleRole
Alignment
Band
Border
BorderStyle
CharSet
DWBuffer
DWConflictResolution
DWItemStatus
FillPattern
grColorType
grDataType
grObjectType
grSymbolType
LineStyle
MetaDataType
RichTextToolbarActivation
RowFocusInd
SaveAsType
SQLPreviewFunction
SaveMetaData
SQLPreviewType
WebPagingMethod
Properties of the DataWindow Control and DataStore
Properties
for PowerBuilder DataWindow
DataWindow Events
About return values for DataWindow events
Categories of DataWindow events
DataWindow event cross-reference
Alphabetical list of DataWindow events
BackTabOut
ButtonClicked
ButtonClicking
Clicked
Collapsed
Collapsing
Constructor
DBError
Destructor
DoubleClicked
DragDrop
DragEnter
DragLeave
DragWithin
DropDown
EditChanged
Error
Expanded
Expanding
GetFocus
GraphCreate
HTMLContextApplied
ItemChanged
ItemError
ItemFocusChanged
KeyDown
LoseFocus
MessageText
MouseMove
MouseUp
OnSubmit
Printend
PrintMarginChange
PrintPage
PrintStart
ProcessEnter
RButtonDown
Resize
RetrieveEnd
RetrieveRow
RetrieveStart
RichTextCurrentStyleChanged
RichTextLoseFocus
RichTextLimitError
RowFocusChanged
RowFocusChanging
ScrollHorizontal
ScrollVertical
SQLPreview
TabDownOut
TabOut
TabUpOut
TreeNodeSelected
TreeNodeSelecting
UpdateEnd
UpdateStart
WSError (Obsolete)
Methods for the DataWindow Control
AboutBox (obsolete)
AcceptText
CanUndo
ClassName
Clear
ClearValues
Collapse
CollapseAll
CollapseAllChildren
CollapseLevel
Copy
CopyRTF
Create
CreateError (obsolete)
CreateFrom
CrosstabDialog
Cut
DBCancel
DBErrorCode (obsolete)
DBErrorMessage (obsolete)
DeletedCount
DeleteRow
Describe
Drag
Expand
ExpandAll
ExpandAllChildren
ExpandLevel
ExportJson
ExportRowAsJson
Filter
FilteredCount
Find
FindGroupChange
FindNext
FindRequired
FindRequiredColumn (obsolete)
FindRequiredColumnName (obsolete)
FindRequiredRow (obsolete)
Generate (obsolete)
GenerateHTMLForm (obsolete)
GenerateResultSet
GenerateXHTML (obsolete)
GenerateXMLWeb (obsolete)
GetBandAtPointer
GetBorderStyle
GetChanges
GetChangesBlob (obsolete)
GetChild
GetChildObject (obsolete)
GetClickedColumn
GetClickedRow
GetColumn
GetColumnName
GetContextService
GetFormat
GetFullContext (obsolete)
GetFullState
GetFullStateBlob (obsolete)
GetItem (obsolete)
GetItemDate
GetItemDateTime
GetItemDecimal
GetItemFormattedString
GetItemNumber
GetItemStatus
GetItemString
GetItemTime
GetItemUnformattedString
GetLastError (obsolete)
GetLastErrorString (obsolete)
GetMessageText (obsolete)
GetNextModified
GetObjectAtPointer
GetParent
GetRichTextAlign
GetRichTextColor
GetRichTextFaceName
GetRichTextSize
GetRichTextStyle
GetRow
GetRowFromRowId
GetRowIdFromRow
GetSelectedRow
GetSQLPreview (obsolete)
GetSQLSelect
GetStateStatus (obsolete)
GetText
GetTrans
GetUpdateStatus (obsolete)
GetValidate
GetValue
GroupCalc
Hide
ImportClipboard
ImportFile
ImportJson
ImportJsonByKey
ImportRowFromJson
ImportString
InsertDocument
InsertRow
IsExpanded
IsRowSelected (obsolete)
IsSelected
LineCount
ModifiedCount
Modify
Move
OLEActivate
OneTrip (obsolete)
Paste
PasteRTF
PointerX
PointerY
Position
PostEvent
Print
PrintCancel
ReplaceText
ReselectRow
Reset
ResetInk
ResetTransObject
ResetUpdate
Resize
Retrieve
RowCount
RowsCopy
RowsDiscard
RowsMove
SaveAs
SaveAsAscii
SaveAsFormattedText
SaveInk
SaveInkPic
SaveNativePDFToBlob
Scroll
ScrollFirstPage (obsolete)
ScrollLastPage (obsolete)
ScrollNextPage
ScrollNextRow
ScrollPriorPage
ScrollPriorRow
ScrollToRow
SelectedLength
SelectedLine
SelectedStart
SelectedText
SelectRow
SelectText
SelectTextAll
SelectTextLine
SelectTextWord
SelectTreeNode
SetAction (obsolete)
SetActionCode (obsolete)
SetBorderStyle
SetBrowser (obsolete)
SetChanges
SetColumn
SetColumnLink (obsolete)
SetCultureFormat
SetDetailHeight
SetDWObject (obsolete)
SetFilter
SetFormat
SetFullState
SetHTMLAction (obsolete)
SetHTMLObjectName (obsolete)
SetItem
SetItemDate (obsolete)
SetItemDateTime (obsolete)
SetItemNumber (obsolete)
SetItemStatus
SetItemString (obsolete)
SetItemTime (obsolete)
SetPageSize (obsolete)
SetPosition
SetRedraw
SetRichTextAlign
SetRichTextColor
SetRichTextFaceName
SetRichTextSize
SetRichTextStyle
SetRow
SetRowFocusIndicator
SetSelfLink (obsolete)
SetServerServiceClasses (obsolete)
SetServerSideState (obsolete)
SetSort
SetSQLPreview
SetSQLSelect
SetTabOrder
SetText
SetTrans
SetTransObject
SetValidate
SetValue
SetWeight (obsolete)
SetWSObject (Obsolete)
ShareData
ShareDataOff
Show
ShowHeadFoot
Sort
TextLine
TriggerEvent
TypeOf
Undo
Update
Methods for Graphs in the DataWindow Control
CategoryCount
CategoryName
Clipboard
DataCount
FindCategory
FindSeries
GetData
GetDataDateVariable
GetDataLabelling
GetDataNumberVariable
GetDataPieExplode
GetDataPieExplodePercentage
GetDataStringVariable
GetDataStyle
GetDataStyleColorValue
GetDataStyleFillPattern
GetDataStyleLineStyle
GetDataStyleLineWidth
GetDataStyleSymbolValue
GetDataTransparency
GetDataValue
GetSeriesLabelling
GetSeriesStyle
GetSeriesStyleColorValue
GetSeriesStyleFillPattern
GetSeriesStyleLineStyle
GetSeriesStyleLineWidth
GetSeriesStyleOverlayValue
GetSeriesStyleSymbolValue
GetSeriesTransparency
ObjectAtPointer
ObjectAtPointerDataPoint
ObjectAtPointerSeries
Reset
ResetDataColors
SaveAs
SeriesCount
SeriesName
SetDataLabelling
SetDataPieExplode
SetDataStyle
SetDataTransparency
SetSeriesLabelling
SetSeriesStyle
SetSeriesTransparency

Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x