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

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 Received on Wed May 27 1998 - 12:44:53 CEST