> I assume you do a select count(*) to count the rows.

Yes, that is right.

> If the query selects just one column (as is often the case with
> distinct), perhaps you could use
>
> select count (distinct fieldname) from table where ...

I implemented your suggestion. It may only work for the TIB_Cursor
component.

> Why SQL does not allow this syntax with more that one column, I ignore.

Yes, it does reject multiple columns. But, I would always much rather see an
error than receive incorrect results.

Thanks for pointing this out. It will now either give the right answer or
fail with a syntax error until someone enhances the SQL implementation of
InterBase/Firebird.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com