Powerbuilder DataWindow Reference

DayNumber – PB Docs 2017

DayNumber DataWindow expression function Description Gets the day of the week of a date value and returns the number of the weekday. Syntax

Argument Description date The date from which you want the number of the day of the week Return value Integer. Returns an integer (1-7) representing the day of the week of…

LinkUpdateOptions – PB Docs 2017

LinkUpdateOptions property (DataWindow object) Description When the OLE Object control is linked, the method for updating the link information. If the user tries to activate the OLE object and PowerBuilder cannot find the linked file, which breaks the link, LinkUpdateOptions controls whether PowerBuilder automatically displays a dialog box prompting the user to find the file. If you…

Y – PB Docs 2017

Y property (DataWindow object) Description The distance of the specified control from the top of the control’s band. Applies to 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…

Border – PB Docs 2017

Border property (DataWindow object) Description The type of border for the control. Applies to Column, Computed Field, Graph, GroupBox, OLE, Picture, Report, TableBlob, and Text controls Syntax PowerBuilder dot notation:

Describe and Modify argument:

SyntaxFromSql:

Parameter Description controlname The name of the control whose border you want to get or set. When…

LeftA – PB Docs 2017

LeftA DataWindow expression function Description Obtains a specified number of bytes from the beginning of a string. Syntax

Argument Description string The string containing the characters you want n A long specifying the number of bytes you want Return value String. Returns the characters in the leftmost n bytes in string if it succeeds and the…

Ceiling – PB Docs 2017

Ceiling DataWindow expression function Description Retrieves the smallest whole number that is greater than or equal to a specified limit. Syntax

Argument Description n The number for which you want the smallest whole number that is greater than or equal to it Return value The datatype of n. Returns the smallest whole number that…

GraphType – PB Docs 2017

GraphType property (DataWindow object) Description The type of graph, such as bar, pie, column, and so on. Applies to Graph controls Syntax PowerBuilder dot notation:

Describe and Modify argument:

Parameter Description graphname The graph control for which you want to get or change the type. typeinteger (exp) An integer identifying the type of…

Syntax 1 For DataWindow controls and child DataWindows – PB Docs 2017

Syntax 1 For DataWindow controls and child DataWindows Description Scrolls a DataWindow control forward one page, displaying the next group of rows in the DataWindow’s display area. (A page is the number of rows that can be displayed in the DataWindow control at one time.) ScrollNextPage changes the current row, but not the current column….

String – PB Docs 2017

String DataWindow expression function Description Formats data as a string according to a specified display format mask. You can convert and format date, DateTime, numeric, and time data. You can also apply a display format to a string. Syntax

Argument Description data The data you want returned as a string with the specified formatting….

Activation – PB Docs 2017

Activation property (DataWindow object) Description The way the server for the OLE object in the OLE Object control is activated. Choices include letting the user activate the object by double-clicking or putting activation under program control. Applies to OLE Object controls Syntax PowerBuilder dot notation:

Describe and Modify argument:

Parameter Description olecontrolname The…