Subject | Re: [IBO] Additional infor for Float Issue |
---|---|
Author | Geoff Worboys |
Post date | 2005-04-11T00:33:22Z |
> I read my post, here is some more data to help the picute along,Yep, that is more helpful.
> float values coming from source DB such as 2.01110484984334E+15
> going into a Firebird Database as a NUMERIC(18,4), i keep getting
> a 'This is not a valid Floating point value' error, i believe becasue
> IBO converted the params to a string as mentioned in previous post.
Note that 2.01110484984334E+15 cast to numeric(18,4) comes out
as: 2011104849843340.0000 which is more than 18 digits!
If the id's all have no decimal places try using numeric(18,0)
(or BIGINT in FB 1.5) for your id field.
--
Geoff Worboys
Telesis Computing