Subject Re: [firebird-support] Stupid Programmer or a bug?
Author Dalton Calford
Hey Ann,

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

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

Thanks anyway.


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