On Thu, Aug 21, 2008 at 10:23 AM, Paul Hope <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