Hi Helen,

>>> Can any one help I was under the impression that FB implemented
>>> the Int64 field type. Is this true and if so how is it declared.
>>
>> Yes, and it's simply called INT64, like in:
>
> Actually, it's called BigInt, which is ugly, but it's
> standard-conformant. :-(
>
>> create table MyTable (
>> big_id int64,
>
> big_id BigInt,
>
> That's on a 1.5 server. It's not implemented in 1.0.x, so the
> declaration is NUMERIC(18,0) there - again with the Dialect
> restriction.

You're right! Strange - I could have sworn I'd used INT64 somewhere,
in IB6 and/or FB1.0

Must have been in a dream, then ;-)

Sorry for creating confusion!


Greetings,
Paul Vinkenoog