Toad World® Forums

Error in Data Generator Toad for SQL Server 6.6.0.963

Toad for SQL Server 6.6.0.963.

Today I try to generate random datas for my table.

Table is a simple table.

This is the script :

CREATE TABLE dbo.Price (
ProductID INT PRIMARY KEY,
LastUpdate DATE NOT NULL,
Price SMALLMONEY NULL,
Qty INT
)

I open TOOLS - DATA GENERATOR, connect my DB and table and I try to pump/generate datas in it.

I attach a screenshot for details :

I obtain a lot of errors on field - PRICE - . Type of it is : Overflow of value.

As you can see price field is of type smallmoney and your tool set maximum and minimum range of data correctly, minimum : -214748.3648 and mximum : 214748.3647.

But if you analize the value in the bottom of the window - preview of generated data first 1000 rows - you can see for example, line 4 : 46235357, line 8 : 804436644, etc,etc,.. is not in the range and this generate the problem.

Values generated is 1000 and if I analyze the data I fond a lot of errors.

The same problem is present in the last BETA Toad for SQL Server Beta 6.7.0.112.

Can you correct this problem please ?

Best regards,

Sergio

Hi Sergio,

From your screenshot, I see the decimal digits is 4, but not show decimal number in generated data. Could you please provide more details? Like your system format setting? Or toad data grid settings?

Thanks,

Kelly

Hi Kelly,

many thank's for your answer.

I attach a screenshots of mine system format settings :

and Toad grid settings :

I stay tune for your answer,

Best regards,

Sergio

Thank you very much, Sergio.

I set format like you provide, also has the generate data problem. I create TSS-1266 for this.

For now, we just can change decimal symbol from “,” to “.” , then it can work.

Sorry for your inconvenience.

Kelly

Hi Kelly,

many thank’s for the support and test.

I can’t change my regional settings because I’m italian and in Italy we use these symbols to works every day.

The problem is of your product. Toad must consider the regional settings of every country.

For now I wait until the problem will be solved.

What’s do you think of my consideration ?

Best regards,

Sergio

Hi Kelly,

last beta of Toad for SQL Server Beta 6.8.0.182 and the problem is still present.

Best regards,

Sergio

Hello ?

Is anybody there ?

Best regards,

Sergio

Hi,

last beta of Toad for SQL Server Beta 6.8.0.249 and the problem is still present.

How can I use a tool if it doesn’t work ?

Can someone tell me more about this ?

Best regards,

Sergio

Hello ?

Is anybody there ?

Best regards,

Sergio

Hi Sergio

We have some developers out on holiday right now. I did forward this to another who is looking at it yesterday, but I forgot the most critical step, notifying you of this. We do have a ticket open for this.

Kathy

Hi Kathy,

many thank’s for your support.

I 'll think to see the problem solved for the next beta or official release of TOAD SS.

I stay tune for your answer when the problem will be solved.

Best regards,

Sergio

Last beta Toad for SQL Server Beta 6.8.0.301 (64 bit).

The problem is still present.

Best regards,

Sergio

Last beta version of Toad for SQL Server Beta 6.8.0.636 (32 bit) and the problem is STILL present.

I open this case/ticket in January 2016.

How can I use your data generator if this doesn’t works ?

Any suggestion about this problem it’s very appreciate .

Best regards,

Sergio