Decimal places for floating point and money numbers

The simplest way to populate your database with test data.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, Lionel, Emma A, sherr

Decimal places for floating point and money numbers

Postby MartinH » Wed Jan 11, 2012 1:53 pm

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.
MartinH
 
Posts: 64
Joined: Fri Apr 15, 2005 9:13 am

Postby eddie davis » Thu Jan 12, 2012 6:01 pm

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
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby MartinH » Thu Jan 12, 2012 6:12 pm

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.
MartinH
 
Posts: 64
Joined: Fri Apr 15, 2005 9:13 am

Postby eddie davis » Tue Jan 17, 2012 4:12 pm

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
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby MartinH » Wed Jan 18, 2012 9:49 am

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/T2dkMFh1Uz ... fd835fcd47

HTH,
Martin.
MartinH
 
Posts: 64
Joined: Fri Apr 15, 2005 9:13 am

Postby tilo23 » Thu Jan 19, 2012 10:14 am

I can see the same issue on my UK based machine...
Inside the Dilbert's world
tilo23
 
Posts: 19
Joined: Thu Dec 22, 2011 3:56 pm
Location: Berkshire, UK

Postby eddie davis » Tue Jan 24, 2012 11:31 am

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
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Data Generator 2

Who is online

Users browsing this forum: No registered users and 0 guests