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.

>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. ;-)

./heLen