Scroll Bar Interaction at Runtime

The position of the scroll bar thumb in the scroll bar alley gives visual feedback to the operator about the relative position of the current record within the block's current record set.

Note, however, that in the case of a query, the scroll bar thumb indicates the position of the current record within the set of records that have been fetched so far. This may or may not include all records that match the query criteria.

For example, if 100 records match the query criteria but only 10 records are being fetched at a time, moving the scroll bar thumb to the bottom of the scroll bar alley would display the 10th record, not the 100th. Moving the scroll bar down again causes Oracle Forms to fetch the next set of 10 records.

Note:You can override the default array fetch mechanism for a block by calling the EXECUTE_QUERY Built-in with the ALL_RECORDS parameter. Doing so, however, is not recommended when the set of records is likely to be large.