Fabien - thank you. I have found that I can't correct the float type fields
so integer is the thing!
Thanks
Bill
--
View this message in context:
http://old.nabble.com/sqlite3-float-value-errors-tp27915161p27923775.html
Sent from the gambas-user mailing list archive at Nabble.com.
---
more of the accounting program store the currency in integer... as
float manipulation is not perfect and cause many error
2010/3/16 Bill-Lancaster :
>
> Thanks for the ideas re storing money values as integer.
>
> For the time being I'll just clean up my float type money fields.
>
> Bill Lancaster
Thanks for the ideas re storing money values as integer.
For the time being I'll just clean up my float type money fields.
Bill Lancaster
--
View this message in context:
http://old.nabble.com/sqlite3-float-value-errors-tp27915161p27916854.html
Sent from the gambas-user mailing list archive at
Jorge Carrión ha scritto:
>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
>
>
>
>>Yes - that IS much simpler but I have found that some of my SQL fields are
>>not exact money values (like 10.23
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
>
> 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 val
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. f
why don't use if hResult!Dr <> hResultInvoice!GrossValue then... ?
2010/3/16 Bill-Lancaster
>
> Sorry, I'm using Gambas 2.13 running in Ubuntu 9.1
> --
> View this message in context:
> http://old.nabble.com/sqlite3-float-value-errors-tp27915161p27915184.html
> Sent from the gambas-user mailing
Sorry, I'm using Gambas 2.13 running in Ubuntu 9.1
--
View this message in context:
http://old.nabble.com/sqlite3-float-value-errors-tp27915161p27915184.html
Sent from the gambas-user mailing list archive at Nabble.com.
--
When comparing two separate database float values :-
if hResult!Dr - hResultInvoice!GrossValue <> 0 then .
Although both values are the same (as far as I can see), the above test
gives a result (of zero)
I've tried converting the fields to a float type variable but get the same
result.
Any
