--- In firebird-support@yahoogroups.com, Criptyk Hayz <kinghayz@s...>
wrote:

> SQL ERROR Code = -104 user name required on this statement:
>
> select s.pick, s.style, s.color, s.fgsize, sum(s.quantity)
> from pick_summary s
> where s.pick = '0187'
> group by s.pick, s.style, s.color, s.fgsize
> order by s.pick, s.style, s.color, s.sizesubscript
>
> Any ideas?

You should install proper client software version including
firebird.msg and you'll see real exception message. You can't order by
column not included in group by clause.

Best regards,
Alexander