Declaring constants – PB Docs 2022
Declaring constants Description Any PowerScript variable declaration of a standard datatype that can be assigned an initial value can be a constant instead of a variable. To make it a constant, include the keyword CONSTANT in the declaration and assign it an initial value. Syntax
|
1 |
CONSTANT { access } datatype constname = value |
The following table shows the parameters used to declare…
Specifying more than one row or column – PB Docs 2022
Specifying more than one row or column Typically you specify one database column as the Columns definition and one database column for the Rows definition, as in the printer crosstab. But you can specify as many columns (or expressions) as you want. For example, consider a crosstab that has the same specification as the crosstab…
SetContent – PB Docs 2022
SetContent Description Sets the content of this PBDOM_ATTRIBUTE. Syntax
|
1 |
pbdom_attribute_name.SetContent(pbdom_object pbdom_object_array) |
Argument Description pbdom_attribute_name The name of the PBDOM_ATTRIBUTE pbdom_object_array An array of PBDOM_OBJECTs Return value PBDOM_OBJECT. This PBDOM_ATTRIBUTE modified. Throws EXCEPTION_ILLEGAL_PBOBJECT — One of the array items is not a valid PBDOM object. This can happen if the array item has not been initialized properly…
The RichText edit style – PB Docs 2022
The RichText edit style You can use the RichText edit style to display column data in a rich text format, and to use different fonts and colors in the same data field. Note The RichText edit style column performs slowly in the Grid and Tabular DataWindows. It is recommended to use the RichText edit style…
Alphabetical list of DataWindow expression functions – PB Docs 2022
Alphabetical list of DataWindow expression functions Contents Abs ACos Asc AscA ASin ATan Avg Bitmap Case Ceiling Char CharA Cos Count CrosstabAvg CrosstabAvgDec CrosstabCount CrosstabMax CrosstabMaxDec CrosstabMin CrosstabMinDec CrosstabSum CrosstabSumDec CumulativePercent CumulativeSum CurrentRow Date DateTime Day DayName DayNumber DaysAfter Dec Describe Exp Fact Fill FillA First FontHeight GetPaintDC GetPaintRectHeight GetPaintRectWidth GetPaintRectX GetPaintRectY GetRow GetText Hour…
Specifying which rows to include in a graph – PB Docs 2022
Specifying which rows to include in a graph The Rows drop-down list allows you to specify which rows of data are graphed at any one time: Setting Meaning All Graphs the data from all the rows that have been retrieved but not filtered or deleted (that is, the rows in the primary buffer of the…
Ink.property – PB Docs 2022
Ink.property property (DataWindow object) Description Properties that control the attributes of ink in an InkPicture control or a column with the InkEdit edit style. Applies to Column and InkPicture controls Syntax PowerBuilder dot notation:
|
1 2 |
dw_control.Object.inkpicname.Ink.property dw_control.Object.columnname.Ink.property |
Describe and Modify argument:
|
1 2 |
"inkpicname.Ink.property { = value }" "columnname.Ink.property { = value }" |
Parameter Description inkpicname The name of an InkPicture control. columnname The name of a column…
Two types of crosstabs – PB Docs 2022
Two types of crosstabs There are two types of crosstabs: Dynamic Static Dynamic crosstabs With dynamic crosstabs, PowerBuilder builds all the columns and rows in the crosstab dynamically when you run the crosstab. The number of columns and rows in the crosstab match the data that exists at runtime. Using the preceding crosstab as an…
Evaluating conditional DataWindow expressions with current data – PB Docs 2022
Evaluating conditional DataWindow expressions with current data Querying a property for a column Values for column properties normally apply to all the rows in the column. For example, if you set the Protect property to “1” for the Emp_Id column, the user will be unable to modify Emp_Id for any of the rows. If you…
What happens at runtime – PB Docs 2022
What happens at runtime Data stored in a DataWindow object is stored within the actual object itself, so when a window opens showing such a DataWindow, the data is already there. There is no need to issue Retrieve to get the data. PowerBuilder never retrieves data into a drop-down DataWindow that already contains data. For…