2. ASPRunner.NET General questions
  3. [SOLVED]  how to save a number as decimal in mssql with asprunner.net?
This topic is locked
[SOLVED]

 how to save a number as decimal in mssql with asprunner.net?

 		12/23/2015 10:12:55 AM
ASPRunner.NET General questions
C
 ccvvccc author

Hi folks,
I have searched the forum but couldnt find proper answer.
I have three columns on mssql.
type 1 is decimal. (decimal(18,2))

type 2 is money.

type 3 is float.
When I create a project with asprunner.net 8.0 , I can't save numbers as decimals.
The numbers I tried;

30.15

30,15
When I click on save button, It saves the number as 3015.
I tried solution here
But it shows as 3015.00
Thanks for any help...
jadachDevClub member 12/26/2015

I just tested in ASPRunner.Net 8.1 latest build and had no problem at all.
Make sure your properties are set correctly for each of those fields.
View as Number with decimals set as 2
C
 		ccvvccc author 12/29/2015



I just tested in ASPRunner.Net 8.1 latest build and had no problem at all.
Make sure your properties are set correctly for each of those fields.
View as Number with decimals set as 2


Thanks for reply, but I have ASPRunner.Net 8.0 . And I tried again and again.

IT JUST DOESN'T WORK!...
I cannot save a number as 11,22 . So I had to set column type as NVarchar.
Sergey Kornilov admin 12/29/2015

Something doesn't sound right here. 11,22 should not work but 11.22 should.
If you need any help with this publish your application to Demo Account and open a ticket at http://xlinesoft.com/dss/support.asp sending the URL of your app on Demo Account along with instructions on reproducing the issue. 'Demo Account' button can be found on the last screen in the software.
jadachDevClub member 12/29/2015

Will it take 11.22?

Perhaps your comma.11,22 isn't a valid number.
C
 		ccvvccc author 12/30/2015

Actually, the problem occurs with dot, not with comma. Anyway I cant write comma in html5 input type=number.
When I try to save 11.22 , It saves as 1122.
I have uploaded project to demo account. Yes It worked.
But on my server (Windows Server 2012 R2 Standart, IIS 8.5) it doesnt work.
So is that a server issue? IIS express and IIS 8 differency? or system language or culture issue?
Sergey Kornilov admin 12/30/2015

Looks like web server misconfiguration. Make sure that in Regional Settings on the web server dot (.) is selected as 'Decimal symbol'.
C
 		ccvvccc author 1/4/2016



Looks like web server misconfiguration. Make sure that in Regional Settings on the web server dot (.) is selected as 'Decimal symbol'.


Exactly the solution is as you said. I have configured Region Settings on control panel in windows server 2012.
At first it didnt work. Because I was connecting to server with remote access. And it saved just for my remote session. In administrative tab in regional settings, there are two checkboxes.. Copy these settings for users and new users. I have selected them and restarted server. And bingo, it worked. Thank you very much. This link also helped me.