Helen,

> > >btw. if you're using IB6, define the pk columns as NUMERIC(18,0) - that's
> > >because generators have grown from 32bit (=INTEGER) in IB5.6 to 64bit in
> > >IB6 - unfortunately there is no INT64 sql type in IB6, but NUMERIC(18,0)
> > >*is* actually a 64bit int.
> >
> >Don't define the pk columns bigger than you need to. If they're used as FK's
> >in other tables you'll be wasting a lot of space if you use 8 bytes when 2
> >or 4 will do.
>
> Error here, Ray. Generators under IB 6 Dialect 3 are 64-bit integer (numeric(18,0)). If you define the PK as integer, the generator value won't fit into it.

perhaps he meant that if your database does not store billions of
records you may resort to 32bit integers and be happy with the least
significant longword of the generator value only.

I'd stick to 64 bit integers anyway; I don't think that saving that
space is worth it, generally.
Ciao
--
____
_/\/ando