Use Dot Decimal - Fixed

[john w]

I need to use the . (dot) for the decimal and the comma for currency. I cannot find a way to set this for my application. I have set the - usedotdecimal - parameter and changed it to 'Yes' for the data type the for the field, but it has not resulted in a visible change. I know this must be a simple setting can someone give me some guidance.

****Update 1:
I tried R. Bianco suggestions. When I check Number Separator(s) under the data window it does not stay checked. I have tried saving it different ways and it stays unchecked when I open the data parameters window. Changes I make in other parameter windows are saved. So is this a bug?

****Update 2:
When I query the data in the table it shows the amount and has the dot for the decimal. It seem the issue is related to the display on the panel/forms.

****Update 3:
I tried adding a mask at the form field level. That did not work. However, when I removed the mask the dot for decimal showed in design mode for the form.When I compile the application and run it, the form continues to show the comma for decimal.

[r.bianco]

1. in the left tree, right click over the app
2. wizard -> parameter configuration
3. data section -> use dot decimal

This is the setting for all fields of application. It must work, otherwise i think it's a bug. Oh, make sure you don't set a different visual style in the filed.

[john w]

I tried your settings, I had missed that. However, I am still getting the comma and not the dot as a separator. I have not set any visual styles at this point. I may try a creating a new app for test purposes in case I messed up a setting somewhere, though I feel that is unlikely.

Thanks again for the help.

[g.lanzi]

The solution suggested by r.bianco is correct, but the behavior of the Parameter Configuration Wizard is strange. There are no known bugs in that page, but I'll make some test on it.
To completely solve your problem you can manually change the parameter compilation of your application. Follow these steps:
1. open che Parameters folder inside the application
2. look for the UseDecimalDot constant, double click on it change its value to "YES"

Let me explain how it works. The Parameters Compilation Wizard is only a comfortable way to change the values of all the constants inside the Parameters folder that every application has, so changing these parameters manually (without the wizard) is actually possible. Just like any other constant you can define in your project.

I'll do some test on that wizard to check its functionallity, I'll eventually contact you to complete the analysis.

[john w]

When I check the number separators in the wizard and save the selection does not hold.

I have tried setting the UseDotDecimal parameter as suggested. In fact I tried that first not seeing the option in the Data configuration window. In that have tried different values. I tried Yes, also tried the values of -1,0,1 and True. None work and setting it to Yes will sometime raise a .Net data type error.

When I set the value to Yes, at the parameter level. I find when I go back to check the setting. It typically show a number and not the string 'Yes'. Sometimes the number is 1, sometimes 1.1, sometimes 1000. On those occasions where it is 1.1 I see the .Net error raise saying there is a data type mismatch, 1.1 cannot be converted to integer. Which true. The error is at Line 40 though I cannot determine which object contain the code.

Regardless of those things the page still renders commas in lieu of dots

I have every confidence I could have messed something up, but I have no idea what it could be.

Finally, I will post a video in minutes showing what I see on my desktop and different combinations I try. That may help.

Regards

John W

[john w]

Here is link to the video, I made one error during the video which is also corrected on the video but I did not want to redo the whole thing.

http://screencast.com/t/7ap6IQbRVCU

[g.cassanelli]

Hi, in your video I notice that: parameter UseDecimalDot must be CHARACTER, not Integer nor Decimal...

usedecimaldot.png (19.19 KiB) Viewed 16230 times

[john w]

Giuseppe - Thanks for the pointing out the correct character type. It made perfect sense when I read your post. However, it does not resolve the issue. The application still renders the page with commas and not dots.

I had incorrectly been looking at the data type as the what I type of data of I wanted to have a dot decimal. I really went off the train track there. Your post did really help explain the setting of properties process. As I said before it made perfect sense when I read it. Thanks again!

[john w]

Okay this was fixed by G.Lanzi. I attribute it to his magic. He remotely did what I had been doing and it worked. Hmmmm...the software must not respond well to being cursed at in English. :)

All is well, the magic has been applied and all is well again.

Thanks to everyone.