NEXT-ROWID attribute

Provides the ROWID of the data source row at which the next FILL operation should start. The AVM sets this attribute after each FILL operation in a series of FILL operations to retrieve data source rows in batches. You typically assign the value of this attribute to the RESTART-ROWID attribute before each FILL operation.

Note: This attribute is not marshalled between the client and the AppServer. You are responsible for retrieving, storing, and transporting this attribute value between the client and the AppServer.

Syntax
`data-source-handle`:NEXT-ROWID( `buffer-sequence-number` \| `buffer-name` )

The handle to the Data-source object.

buffer-sequence-number

An integer that represents the sequence number of a buffer in the list of buffers for the Data-source object. Specify buffer-sequence-number to identify a buffer in the Data-source object when the Data-source object is defined against more than one database table buffer. The default is the first (or only) buffer in the Data-source object.

Note: Sequence numbers for buffers in a Data-source object start at one, where one represents the top level and subsequent numbers represent lower levels of join, if any.

A CHARACTER expression that evaluates to the name of a buffer in the list of buffers for the Data-source object.

If an invalid buffer is specified, this attribute returns the Unknown value (?).

It is best to use the NEXT-ROWID attribute with a top-level ProDataSet temp-table, or a child temp-table that has only one parent record, because the AVM sets this attribute on the child temp-table for each parent record (as opposed to once per child temp-table).

Use this attribute when retrieving batches of data source rows containing stable data. Otherwise, it might be better to use a unique index to reopen the query associated with the Data-source object to retrieve a specific batch of data source rows.