SMO with 5 decimal digits

  • 17 December 2015
  • 2 replies
  • 0 views

Badge +7

we need SMO with 5 decimal digits, and i have tried 3 different ways to make it work, but nothing worked out unfortunately

 

i have tried --
1) after creating smo decimal SMO, tried changing style to 5 decimal places, but it still save in database as 2 digits (plz see screenshot)
2) tried changing changing in sql management studio, but it dosen't let me change, its disabled to change any properties (plz see screenshot)
3) exported to sodx file, changed decimal in visual studio smartobjects, importing again, but unfortunately it wont change to 5 digits at all, and revert back to 2 digits decimal points (plz see screenshot)

 

please advice me, 5 digits is very important for me

 

15626i94CE69A0AAB6F36F.png




2 replies

Userlevel 5
Badge +16

Hi,

 

Did you try to change the region settings?

 

if you go to control panel and open Region > Additional settings > No. of digits after decimal(5)

 

13382iB621779A0137E96E.png

 

Note: This has to be done on the server

Badge +7

i will try this, Thanks

Reply