I'm running the RC4 Firebird on a W2k server, using Winxp client and
gds32.dll v5.1.2600.1106 (from with IB oe or FB1).

Just ran the following query:

select
f.facility_name, x.dept, sum(x.variance)
from
cycle_count x
join facility f on (f.facility_id = x.facility_id)
where
x.variance > 0 and
x.account_id = 7
group by
f.facility_name

And received the error message:

Dynamic SQL Error
-SQL error code = -104
-password required


Of course, the problem is that I don't have all columns in the group by
list. The error message caused some concern for a few seconds, thinking FB
had corrupted.

Bob M..