Hi,

I have a table(dialect3) like this:

CREATE DOMAIN UNUMERIC AS
NUMERIC(15,4)

CREATE TABLE ZPURCD (
PURCDNO INTEGER NOT NULL,
AMT UNUMERIC DEFAULT 0 NOT NULL,
ACCTNO INTEGER NOT NULL,
PURCMNO INTEGER NOT NULL
);

When query the table in IB6 with following sql:

select acctno, sum(amt) from zpurcd
group by acctno

I got acctno, F_1 from IB6

but I got :
Acctno, SUM from Firebird 1.03

the simple solution is I change the query to:

select acctno, sum(amt) as F_1 from zpurcd
group by acctno

but that requires me to go over the entire program to correct all the
sql statements, is there a way to let FB 1.03 behave like IB6 in this
case?

Thanks,

FrankW