[Gambas-user] sqlite3 float value errors

[Jorge Carrión]

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-lancaster at ...2231...>

>
> 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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>