[Gambas-user] sqlite3 float value errors

[Bill-Lancaster]

Yes - that IS much simpler but I have found that some of my SQL fields are
not exact money values (like 10.23 say) but have tiny extra decimal values.

These display as normal in a gridview, tableview or whatever.

By converting SQL field to float called fTempVal
then  fTempVal=fTempVal * 100.   fTempVal - Int(fTempVal) gives a very small
decimal value.

Clearly my money values in the SQL database are not exact, unfortunately
they were displayed as normal.

Bill Lancaster


-- 
View this message in context: http://old.nabble.com/sqlite3-float-value-errors-tp27915161p27915529.html
Sent from the gambas-user mailing list archive at Nabble.com.