Try OpenEdge Now
skip to main content
ABL Reference
Handle Attributes and Methods Reference : RESTART-ROW attribute
 

RESTART-ROW attribute

Allows the FILL query to be repositioned to an absolute row number. Similar to RESTART-ROWID, this attribute facilitates batching during a FILL on a ProDataSet temp-table.
Data type: INTEGER
Access: Readable/Writeable
Applies to: Data-source object handle
Setting this attribute is helpful when you are paging back and forth in a table and want to retrieve, for example, page 3. The BATCH-SIZE attribute is used to calculate the row where a given page begins, and RESTART-ROW is set to that value just before the FILL. This causes the FILL query to be repositioned to the correct "page". For example, to get page 3 you set RESTART-ROW to (3-1) * BATCH-SIZE to fill the third group of records.

Syntax

RESTART-ROW ( row )
row
An integer expression indicating the absolute row number to reposition the query.

See also

BATCH-SIZE attribute, RESTART-ROWID attribute