try BIGINT instead of INTEGER.

-stan

--- In firebird-support@yahoogroups.com, "martinknappe" <martin@...>
wrote:

>
> this may seem like a stupid question but when i declare a table field
> in firebird as an integer, what is it internally by default? 64 or 32
> bits? if 32 bits, how do i change that to 64 bits?
>
> --- In firebird-support@yahoogroups.com, "Gary Benade" <gary@> wrote:
> >
> > Quote from http://www.fingerbird.de/generatorguide.htm
> > >So if you would feed a column with a Dialect 3 Generator, and you
> would
> > >insert 1000 rows per second, it would take roundabout 300 million
> >years
> > >(!) before it rolls over. As it is pretty unlikely mankind will
> still walk
> > >on this planet by then (and still use Firebird databases), that's
> nothing
> > >to >be really worried about :-)
> >
> > They said the same thing when the decided on 512k ram! I bet in 300
> million
> > years some poor programmer maintaining a legacy banking app is

going to

> > google that and weep ;)
> >
>