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