At 09:41 AM 13-06-01 +0100, Ray Drew wrote:

>re Frank's comment:
>
> >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.

Regards,
Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________