Hey Ann,

It was a combination of problems, both with user and software, but not
Firebird.

I finally got what I needed, but I found a problem in the IB_SQL program
when it deals with preparing a group by query.
Instead of reporting a stupid user error back from the database, it went
into an infinite loop.
Luckily, I had a coffee, used ISQL, found my error and got the answer I
needed.

Thanks anyway.

Dalton

Ann W. Harrison wrote:

>
> Dalton Calford wrote:
> >
> > So I use IB_SQL to create a simple query
> >
> > select zone, description, count(description) as calls, sum(duration)
> > from report group by calls order by description
>
> That should have returned an error because you're returning
> simple fields - not aggregates - that aren't in the grouping list.
>
> I'm not sure what you're trying to do, but I doubt very much
> that you can group by an aggregate that depends on the grouping.
>
> What are you trying to do?
>
> Regards,
>
> Ann
>
>