> <paulhope@...> wrote:
> > My understanding is that generators are now 64 bit with no option.
> > 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.
>
> I believe that if you don't change the columns datatype,
> firebird will automatically cast the generators to int32.
> Or if you prefer to cast explicitly :
> cast(gen_id(generator, 1) as integer)
>
> But you don't *have to* change columns and variables.
>
> hth,
> []s
> --
> Douglas Tosi
> www.sinatica.com