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. ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
