Rick Debay wrote:

> Never mind. I reread the section where you wrote "Views that uses
> aggregates on FB 1.5 move the WHERE clause to the HAVING clause".
> That explains why it takes as long as an unfiltered query, where I want
> results for all entities, not just one.
> Until IBObjects allow us to move to FB2, we'll just have to change our
> business process to run all reports at once instead of on demand.
>
>

Or use a direct select on tables instead of views.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br