Subject Re: [IBO] Additional infor for Float Issue
Author Geoff Worboys
> I read my post, here is some more data to help the picute along,

> 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.

Yep, that is more helpful.

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