Query Hits Property
Description
Specifies the NUMBER value that indicates the number of records identified by the COUNT_QUERY operation. If this value is examined while records are being retrieved from a query, QUERY_HITS specifies the number of records that have been retrieved.
This property is included primarily for applications that will run against non-ORACLE data sources.
Applies to block
Set programmatically
Refer to Built-in
GET_BLOCK_PROPERTY
SET_BLOCK_PROPERTY
Usage Notes
This property can be used in several ways:
- In an application that runs against a non-ORACLE data source, use SET_BLOCK_PROPERTY(QUERY_HITS)
in an On-Count trigger to inform Oracle Forms of the number of records
that a query will return. This allows you to implement count query processing
equivalent to Oracle Forms default Count Query processing.
- Use GET_BLOCK_PROPERTY(QUERY_HITS) during Count Query processing to examine
the number of records a query will potentially retrieve.
- Use GET_BLOCK_PROPERTY(QUERY_HITS) during fetch processing to examine the
number of records that have been retrieved by the query so far and placed
on the block's list of records.
Query_Hits Restrictions
Set this property greater than or equal to 0.