Subject | Re: Field.AsInt64 (was Re: [IBO] How to get the record id that was just stored with a query) |
---|---|
Author | Geoff Worboys |
Post date | 2005-07-01T04:33:29Z |
> 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:
http://www.ibobjects.com/docs/TI_Numerics.rtf
NB. "BCD" fields use the currency data type internally.
--
Geoff Worboys
Telesis Computing