Subject Re: Field.AsInt64 (was Re: [IBO] How to get the record id that was just stored with a query)
Author Geoff Worboys
> It's probably OK to use it for casting, provided you don't
> try to perform scale-raising calculations with those numbers.
> No doubt if Geoff sees this thread he will have more to say
> about it...

I am wondering if we have some wires crossed somewhere. I am
not aware of any problems with Int64 vs BigInt or NUMERIC(18,0)
indeed I use AsInt64 quite a lot.

I am aware of issues with the Delphi currency data type when
mixed with IB/FB scaled integer types. ie. currency matches
NUMERIC(18,4), if you mix it with NUMERIC(18,2) (as a common
example) you may run into problems. Details in:

NB. "BCD" fields use the currency data type internally.

Geoff Worboys
Telesis Computing