|Subject||Re: Field.AsInt64 (was Re: [IBO] How to get the record id that was just stored with a query)|
> It's probably OK to use it for casting, provided you don'tI am wondering if we have some wires crossed somewhere. I am
> try to perform scale-raising calculations with those numbers.
> No doubt if Geoff sees this thread he will have more to say
> about it...
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.