Subject Re: [firebird-support] Problem when Updating Column With Float DataType
Author Martijn Tonies

> When I tried to update a column with float datatype, the value that I
> updated is not what I enter earlier.
> for example:
> update table1 set value = 44090914
> where id = 1;
> when I retrieve this record, the value is 44090912. is it hit the
> maximum value of float data type ?

If you want more precision - try the Double Precision datatype.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions