"Sort record size of <number> bytes is
too big"

That's the sum total of all information I could find on the error
from the fb manual or a relentless hour of searching on the 'net.

It's FB 1.5 on Windows and to reproduce the error I moved the query
to IBManager out of my application just to be sure.

It's appearing with a *very* large query that was working fine right
up until I joined one more table to it. I can run the query if I
take out the Order By clause but if I add the order by clause with
even only one field referenced in it I get that error.

It's the first problem I've run into with FireBird that I couldn't
resolve and it's got me stumped completely.

I'm not sure where to start looking to resolve this any ideas would
be gratefully appreciated.