Re: Total records in block

[Quoted] Yes, I surrender, the "thousands of record" make "query all records" a bad way; dealing with on-message is not one favorite of mines, though. If you have issued a count_query, then
"get_block_property('<block_name>', query_hits)" will give you the number of record (in varechar2 format).

Regards,
Maurício.

In article <37CCED02.1774884D_at_dd.ru>, [Quoted]   Valeri Sorokine <vsorokin_at_dd.ru> wrote:
> Yeah, especially in the block with complicated POST-QUERY trigger!
>
> I don't think that a setting the "Query All Records" property to True
is
> a very fast solution...
>
> The Forms counts all records easily and fast by Count_Query built-in.
>
> Still offer the using Count_Query...
>
> Hope this will help.
>
> Kirill Dylewski wrote:
> >
> > How about query executing time if there are 5000...10000...20000
records in
> > block?
>
> --
> Valeri Sorokine
> ProSoft, Russia, Moscow, Information Systems Division
> Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
> E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoft.ru
> http://www.dd.ru
>

--
Maurício B. Falleiros <mbf_at_uniconsult.com.br>
Uniconsult Sistemas e Serviços


Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.