Using the ADO.NET Interface

CollapseAll – PB Docs 126

CollapseAll method (DataWindows) Description Collapses all groups in a TreeView DataWindow. Controls DataWindow type Method applies to PowerBuilder DataWindow control Syntax [PowerBuilder]

Argument Description dw_control A reference to a TreeView-style DataWindow control Return Values Returns 1 if the CollapseAll operation succeeds and one of the following negative values if it fails: -1 DataWindow is…

X – PB Docs 126

X DataWindow object property Description The distance of the specified control from the left edge of the DataWindow object. Controls Button, Column, Computed Field, Graph, GroupBox, OLE, Oval, Picture, Rectangle, Report, RoundRectangle, TableBlob, and Text controls Syntax PowerBuilder dot notation:

Describe and Modify argument:

Parameter Description controlname The name of the control for…

SuppressEventProcessing – PB Docs 126

SuppressEventProcessing DataWindow object property Description Whether the ButtonClicked or ButtonClicking event is fired for this particular button. Controls Button controls Syntax PowerBuilder dot notation:

Describe and Modify argument:

Parameter Description buttonname The name of the button control for which you want to suppress event processing. value Whether event processing is to occur. Values…

Syntax – PB Docs 126

Syntax DataWindow object property Description The complete syntax for the DataWindow. Controls DataWindows Syntax PowerBuilder dot notation:

Describe argument:

Examples

Document get from Powerbuilder help Thank you for watching.

SQLPreviewType – PB Docs 126

SQLPreviewType DataWindow constant Description Values passed to the SQLPreview DataWindow event to indicate what SQL statement is being sent to the DBMS. Values PowerBuilder enumerated value Numeric value Meaning PreviewSelect! 1 A SELECT statement PreviewInsert! 2 An INSERT statement PreviewDelete! 3 A DELETE statement PreviewUpdate! 4 An UPDATE statement See Also SQLPreview Document get from…

CumulativeSum – PB Docs 126

CumulativeSum DataWindow expression function Description Calculates the total value of the rows up to and including the current row in the specified column (a running total). Syntax

Argument Description column The column for which you want the cumulative total value of the rows up to and including the current row for group. Column can…

Syntax for a range of data in a named column – PB Docs 126

Syntax for a range of data in a named column Description A DataWindow data expression accesses values in a named column or computed field for a range of rows when you specify the starting and ending row numbers. Syntax

Parameter Description dwcontrol The name of the DataWindow control or child DataWindow in which you…

Syntax for a single data item in a DataWindow – PB Docs 126

Syntax for a single data item in a DataWindow Description A DataWindow data expression accesses a single data item when you specify its row and column number. Syntax

Parameter Description dwcontrol The name of the DataWindow control or child DataWindow in which you want to get or set data. buffer (optional) The name of…

Arithmetic operators in DataWindow expressions – PB Docs 126

Arithmetic operators in DataWindow expressions When you write an expression, you can use the following arithmetic operators: Table 1-5: Using expressions with arithmetic operators Operator Meaning Example + Addition SubTotal + Tax – Subtraction Price – Discount * Multiplication Quantity * Price / Division Discount / Price ^ Exponentiation Rating ^ 2.5 Multiplication and division…

What you can do with DataWindow object properties – PB Docs 126

What you can do with DataWindow object properties The DataWindow object defines the way data is displayed in a DataWindow control. It contains controls that represent the columns, text labels, computed fields, and images. The properties of the DataWindow object and its controls store the information that specifies the behavior of the DataWindow object. They…