hi,

I use IB6's gbak to backup a IB6 gdb and gbak -C using FB1.5 to
restore the gdb to fdb.

I have a table:

CREATE TABLE CVPMT (
CVNO INTEGER NOT NULL,
SEQ USEQ NOT NULL,
PMTTNO INTEGER NOT NULL,
AMT UNUMERIC NOT NULL,
CHECKNO VARCHAR(20),
CHECKDATE UDATE,
SREMARK USREMARK,
SLMSTNO USEQ,
CLIENTNO INTEGER,
ACCTNO INTEGER NOT NULL
);

if I do a 'select acctno from cvpmt', everything is ok, but if do:
'select acctno from cvpmt p, account a where p.acctno = a.acctno'
I got an error:

Dynamic SQL Error.
SQL error code = -204.
internal gds software consistency check (table CVPMT).
ACCTNO.

but if i tried the above in IB6, no error at all, why?

thanks,

Frank