Retrieve.AsNeeded

Description

Whether rows will be retrieved only as needed from the database. After the application calls the Retrieve method to get enough rows to fill the visible portion of the DataWindow, additional rows are “needed” when the user scrolls down to view rows that have not been viewed yet.

Applies to

DataWindows

Syntax

PowerBuilder dot notation:

dw_control.Object.DataWindow.Retrieve.AsNeeded

Describe and Modify argument:

"DataWindow.Retrieve.AsNeeded { = ' value ' }"

Parameter	Description
value	Whether rows will be retrieved only as needed from the database. Values are: Yes – Rows will be retrieved only as needed. No – All rows will be retrieved when the Retrieve method is called.

Parameter

Description

value

Whether rows will be retrieved only as needed from the database.

Values are:

Yes – Rows will be retrieved only as needed.
No – All rows will be retrieved when the Retrieve method is called.

Usage

In the painter

Set the value using Rows>Retrieve Options>Rows As Needed.

Examples

Example 1

string setting

setting = dw1.Object.DataWindow.Retrieve.AsNeeded

dw1.Object.DataWindow.Retrieve.AsNeeded= "Yes"

Example 2

setting = dw1.Describe("DataWindow.Retrieve.AsNeeded")

dw1.Modify("DataWindow.Retrieve.AsNeeded=Yes")