Hi Helen

> At 23:23 21/08/2008, Paul Hope wrote:
> >We are currently converting from FB1.5 D1 to FB2.1 D3.
> Everything is
> >relatively painless until we get to generators ;-/ My
> understanding is
> >that generators are now 64 bit with no option.
>
> True, but Firebird generators have always been 64-bit.

Never realised that since always applied them to integers.

>
> >Therefore all table columns set by generators have to be changed to
> >bigint, all SP and trigger variables/parameters handling
> these columns
> >or derivitives of them need to be changed and all Delphi
> references to
> >them need to be changed.
>
> No.
>
> >
> >Moving from int to bigint generators is of zero benefit to
> me while the
> >pain of conversion will be HUGE.
> >
> >Is there any other option?
>
> Yes. Just carry on with life. And be prepared for an
> overflow exception when your first generator hits the number
> 2,147,483,648 and tries to write it into an integer column. ;-)

That's a relief ;-) Hopefully I'll be dead by the time that happens!

Regards
Paul