Re: Forms4.5: How can I show the record position in the block?

[Quoted] But there is a QUERY_HITS block property, which we can use after wery fast Count_Query operation...
Execute_query(ALL_RECORDS) is more slowly I think

hts_no_spam__at_core.no wrote:
>
> In article <356BE5A3.3BBB5E25_at_dd.ru>, vsorokin_at_dd.ru
> says...
> > Thank you! This is the nice solution.
> >
> > But one more question.
> >
> > Why Forms from Developer/2000 v1.5 dysplay current position in block
> > like '3/?' in the status bar?
> > After fetching all records we can see, for example, '3/134'.
> > Why Oracle cannot dysplay count all records immediately?
>
> Forms doens't know how many rows there are and a call to
> count_query could be expensive. If you want Forms to
> get all the records and update the counter you can use
> execute_query(ALL_RECORDS) when performing the query.
> This obviously takes longer, since forms will get all
> the records queried. This also gets rid of the
> irritating scroll bar problem.
>
> Haakon T Soenderland
> Core Technology AS
> www.core.no | hts_at_core.no

-- 
Valery A. Sorokin
ProSoft, Russia, Moscow