Re: Query Hits Question

Joseph Strano wrote:
>
> In the PRE-QUERY trigger, use DBMS_SQL to fire the same query that the
> block is based on, but have it return a count instead of data. That
> will give you the total # of records. Next, use
> WHEN-NEW-RECORD-INSTANCE that displays :SYSTEM.CURSOR_RECORD to
> give you the current record #.
>
> Remember, that DBMS_SQL is PL/SQL v2 and can not be stored in the form.
> The program unit will have to be stored in the database.
>

So why use it? Just use a cursor in the PRE-QUERY with the same WHERE clause as the block, returning a count. We do this both in that case, and in the case where we require a total value to be displayed, before all records have been read.

-- 
The above posting represents the personal opinions of the author and
is not to be taken as official (or unofficial) policy or opinions of 
his employer.

Alex Heney, Living in the Global Village.