Topic: POSSIBLE BUG: TableGrid, Date, Float and some questions
Hello,
I have some questions, hopefully no problems...
.
Table Grid:
Date are not shown. I have checked the database. The date is stored as dd.mm.yyyy and not as dd.mm.yyyy hh.mm.ss.xxx. I am using sql statements for storing dates like
update entries set date = datetostr(form1.datetimepicker.datetime)
Anything missing here?
.
Float:
I am located in germany. We have no decimal dot we have decimal comma. Our amounts are shown as
1,98
1.234,98
and not
1.98
1,234.98
calculations does not work with sql statements. When I use
select sum(value) from entries
and I have a lot of values like
1,29; 0,69; 5,63
Only the part before the comma is calculated and the table grid does not show larger amounts, which are written 1.234,98...
Is there any automatic conversation possible to change the , with . and the . with ,
When I use
replacestr('1.234,98', ',' ,'.')
I get 1.234.98 which I can not convert to 1,234.98.
.
Any solutions/ideas?
.
Thank you.
.
Project not attached, because it is written with german dialog text...