----- Original Message -----
From: "Arno Brinkman" <firebird@...>

> all, so this is a little weird. Are you sure this is the problematic
query?

Thank you Arno, you win a prize! I found another query that was causing the
problems, I didn't think there was another one. You cannot use a count SQL
statement that includes an order by. You could do this in earlier versions
of firebird however.

Thanks,
Stephen