| Author |
Message |
MartinH
Joined: 15 Apr 2005
Posts: 61
|
 Posted: Wed Jan 11, 2012 1:53 pm Post subject: Decimal places for floating point and money numbers |
 |
|
Can I indicate how many decimal points floating point numbers should be rounded to?
Also, for min and max values I don't seem to be able to indicate numbers with decimal points. For instance I want to generate numbers from 0.5 to 10, but I can't enter 0.5 as the min value.
Thanks,
Martin. |
|
| Back to top |
|
 |
eddie davis
Joined: 14 Jun 2006
Posts: 796
Location: Red Gate Software
|
| Posted: Thu Jan 12, 2012 6:01 pm Post subject: |
|
|
Hi,
Thank you for your post into the forum.
Have you tried typing directly into the Min and Max boxes? Using the up and down arrows will not let you specify a min value of 0.5 but typing directly should let you specify a min value of 0.5.
Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com |
|
| Back to top |
|
|
MartinH
Joined: 15 Apr 2005
Posts: 61
|
| Posted: Thu Jan 12, 2012 6:12 pm Post subject: |
|
|
Eddie:
Yes I did try this, but I typed 0.5 and in Spain we use the coma to separate decimals, so is should be 0,5 if regional settings are respected.
When I type 0.5 it is converted to 5. When I type 0,5 it is rounded to 1!
Thanks,
Martin. |
|
| Back to top |
|
|
eddie davis
Joined: 14 Jun 2006
Posts: 796
Location: Red Gate Software
|
| Posted: Tue Jan 17, 2012 4:12 pm Post subject: |
|
|
Hi
I tested using V2.0.1.6 using a machine with German regional settings (sorry I did not have a Spanish machine available at the the time of testing) and found the following results:
When I type 0,5 it rounded up to 5. When I type 0.5 it worked as expected.
What version of SQL Data Generator are you using? Meanwhile I will try other means to replicate your fault symptoms.
Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com |
|
| Back to top |
|
|
MartinH
Joined: 15 Apr 2005
Posts: 61
|
|
| Back to top |
|
|
tilo23
Joined: 22 Dec 2011
Posts: 19
Location: Berkshire, UK
|
| Posted: Thu Jan 19, 2012 10:14 am Post subject: |
|
|
I can see the same issue on my UK based machine...
_________________
Inside the Dilbert's world |
|
| Back to top |
|
|
eddie davis
Joined: 14 Jun 2006
Posts: 796
Location: Red Gate Software
|
| Posted: Tue Jan 24, 2012 11:31 am Post subject: |
|
|
Thank you for your replies and the video was a great help.
You will be pleased to hear that I have replicated your problem. My bad, it helps if you use the correct data type to start with. I was using a decimal data type and not the float(n) data type.
Therefore I have created a support call for you, the call reference is F0056192. Also added the support call and forum post details to Bug Report SDG-668.
Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com |
|
| Back to top |
|
|
|
