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