Hi Sean, thanks for the quick reply!

I get that error even when I have one integer column in the order by
clause.
The query contains about 35 tables all LEFT or RIGHT joined in a tree
ultimately to one single table.
The query has been working fine, performance has been excellent and
optimized etc etc.
I just joined in one more table (the last one I needed for the report
as it happened) and that's when this error started.

I suspect the error is misleading since I can reproduce it with only
one column in the order by clause or it's referring to some other
type of sorting.

- JOhn


--- In firebird-support@yahoogroups.com, "Leyne, Sean" <Sean@B...>
wrote:

> What is the total size (in bytes) of the fields/columns referenced

in

> your GROUP or SORT BY clause?
>
>
> Sean
>