Datafield type Decimal doesn't work as expected

  • 17 March 2008
  • 2 replies
  • 3 views

Badge +3

Hello,

 i have a lot of trouble with datafields that are set up as "Decimal".

I use ASP.Net forms, and when i enter a number like "30.1", K2 doesnt understand this as a decimal, so it keeps the datafield to the initial value.

On the other hand, when i enter "30,1" with a coma, K2 does understand this as a decimal. However, my database use dots as decimal separator so the workflow freeze when it comes to writing this value in the database.

 What kind of work around is there to such a problem? In my configuration panel (on the client machine), regional settings, the decimal separator is a dot, so i dont understand where the coma might come from?

 
Any help would be greatly appreciated. Thanks.

 


2 replies

Badge +9
Just taking a guess here.  Given that the error is on the K2 server side, did you check the regional settings for the decimal seperator on the K2 server itself?
Badge

Hi!


I am from Eastern Europe and our decimal separator is coma (,). But when I try to get information from SharePoint throw SmartObject I lose decimal separator in result.


In a SP I have amount value: 100,50


After  SmartObject method execution: 10050


How can I fix this without changing location settings?

Reply