I use integer for money fields without decimals. I store cents... in display just field / 100. Hope it's valid for you
2010/3/16 Bill-Lancaster <bill-lancas...@lineone.net> > > 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 > ------------------------------------------------------------------------------ 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