Red Gate forums :: View topic - Decimal places for floating point and money numbers
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 2
SQL Data Generator 2 forum

Decimal places for floating point and money numbers

Search in SQL Data Generator 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
MartinH



Joined: 15 Apr 2005
Posts: 64

PostPosted: Wed Jan 11, 2012 1:53 pm    Post subject: Decimal places for floating point and money numbers Reply with quote

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
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 937
Location: Red Gate Software

PostPosted: Thu Jan 12, 2012 6:01 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
MartinH



Joined: 15 Apr 2005
Posts: 64

PostPosted: Thu Jan 12, 2012 6:12 pm    Post subject: Reply with quote

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
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 937
Location: Red Gate Software

PostPosted: Tue Jan 17, 2012 4:12 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
MartinH



Joined: 15 Apr 2005
Posts: 64

PostPosted: Wed Jan 18, 2012 9:49 am    Post subject: Reply with quote

Eddie:

I am using the same version.

I have recorded a very short video where you can see the problem, it can be downloaded here:
https://zipsend.com/download/T2dkMFh1UzdwTVhtcXNUQw/M3BreFlkUnFtMElsYzlVag/087830a9830a52e3c5e88b88663ca1fd835fcd47

HTH,
Martin.
Back to top
View user's profile Send private message
tilo23



Joined: 22 Dec 2011
Posts: 19
Location: Berkshire, UK

PostPosted: Thu Jan 19, 2012 10:14 am    Post subject: Reply with quote

I can see the same issue on my UK based machine...
_________________
Inside the Dilbert's world
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 937
Location: Red Gate Software

PostPosted: Tue Jan 24, 2012 11:31 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group