Hi,

> 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
http://www.upscene.com