→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Bart_van_den_Bo
Engaged Sweeper III
Hi,

A serach on this forum did not gave me any information on this issue, so here it goes:

When using the LanSweeper Configuration Utility

"\Licences\Software Licences\Licensed software that you keep track of:"

And enter a value

for example a license price is € 148,55

When i enter this value and press Enter. The value is converted to € 14.855,00

A value of € 1,00 is entered correctly.
A value of € 1,50 is converted to € 15,00.

Using LanSweeper 4.0.0.27 and config utility 4.0.0.113

Any idea what might be causing this and how it is solved?

Thanks,





9 REPLIES 9
Bart_van_den_Bo
Engaged Sweeper III
Ok, thanks. I will change my values to non-decimal for the time being.
Hemoco
Lansweeper Alumni
I'll have to investigate, but it had never the intention to store decimal numbers.
Bart_van_den_Bo
Engaged Sweeper III
Hereby some screenshots of the table properties...

Hemoco
Lansweeper Alumni
sorry, should have checked this before:
This field does not allow numbers after the decimal separator.
Lansweeper wrote:
sorry, should have checked this before:
This field does not allow numbers after the decimal separator.


Did this changed?
Because I DO have records containing numbers after the decimal seperator...
Bart_van_den_Bo
Engaged Sweeper III
unfortunatly no,

It's converted to € 14.855,00
Hemoco
Lansweeper Alumni
When you enter 148.55 do you get the correct result?
Bart_van_den_Bo
Engaged Sweeper III
The decimal seperator is already set as a comma.

I've changed it to a dot, this gave the same results.
Changed it back to a comma, same results.

When entering values into Excel on the same machine a value like 1,50 is entered correctly.

To be sure also restarted the machine, same results.

Any other ideas?

Hemoco
Lansweeper Alumni
Most likely this is caused by the default user language that the database user is configured with (change the decimal separator from point to comma)