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