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

OpenEdge Release 10.2B

Copyright © 2009 Progress Software Corporation