[WM19 android] storing money

Startbeitrag von ccc2 am 06.10.2014 10:47

recently I discover a bugs in WM19 in storing money into sqlite using currency datatype

I try to store 12345.16 but when i retrieve , it show 12345.2
if i store less than 10 000 then no problem


when i open the file using wdmap , it show 12345.16

strange things happen. I try using android app to open the file.
sqlite editor (ver 2.0.1) show me 12345.2
sqlite manager (latest) show me 12345.16

I couldn't resolve this , so i change the code to use datattype interger to store money by times 100 when storing , devide 100 when display.

such a critical bugs and i don't see anyone report this issue in windev english forum .

is this mean no one using WM19 ?

Antworten:

Hi

you say

>>sqlite editor (ver 2.0.1) show me 12345.2
>>sqlite manager (latest) show me 12345.16

So clearly, the data is correct, and the result being correct or not depends on "something"

Which means that:
- MAYBE other WM users don't have your problem because they are doing things differently
- maybe it is hardware/OS version dependent and they are not in your configuration
- maybe they just prefer using HFSQL to have the automatic file modification available
- maybe they are not using currencies... There are after all MANY types of applications who do not need this type of variable.

So I can see quite a few possible explanations about nobody talking about this bug other than nobody using WM 19 :-)

Best regards

von Fabrice Harari - am 06.10.2014 10:59
Quote
Fabrice Harari
Hi

you say

>>sqlite editor (ver 2.0.1) show me 12345.2
>>sqlite manager (latest) show me 12345.16

So clearly, the data is correct, and the result being correct or not depends on "something"

Which means that:
- MAYBE other WM users don't have your problem because they are doing things differently
- maybe it is hardware/OS version dependent and they are not in your configuration
- maybe they just prefer using HFSQL to have the automatic file modification available
- maybe they are not using currencies... There are after all MANY types of applications who do not need this type of variable.

So I can see quite a few possible explanations about nobody talking about this bug other than nobody using WM 19 :-)

Best regards


Hi Fabrice,

I tried on 4 different hardware and all return same issue.

it is known issues for sqlite does not support currency . people either store it as interger or text . when i saw WM has currency datatype , i though WM will store as text and internally do the conversion like Sqlite.NET . I guess i assume too much .

von ccc2 - am 06.10.2014 11:21
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.