bartsmissaert@... schrieb:

> Yes, I understand that, but it would still be
> useful to know the tota number of records in a table without having to do
> a count.

That will be kind of tricky, won't it?
You want Firebird to estimate precisely how many valid records the
current trasaction is seeing with having to count them?
Sounds like an very superb clairvoyant algorithm.

Or sth. like this - almost 40 years old:

I read the news today, oh boy,
4000 holes in Blackburn, Lancashire
And though the holes were rather small
They had to count them all -
Now they know how many holes it takes to fill the Albert Hall

;-)

Luc.