Toad World® Forums

TOAD 6.5.0.3001 and strange behavior

I have a simple table with 5 fields.

I select it and I press right button on it and select GENERATE SQL - INSERT STATEMENT - TO EDITOR and TOAD SS generate an insert statement in editor.

See screenshot for detail :

I see the statement generated. TOAD tell me that there is a problem- line 1, col 1: Incorrect syntax near '' - but I don't understand why ?

I execute, via F5 or F9 the insert statement and all is executed correctly.

I attach a new screenshot after execute it :

Have you some idea about this strange issue ?

This is the metadata of the table :

CREATE TABLE [dbo].[CAUSALI_RAPPORTINI] (

[CODICE] int IDENTITY(1, 1) NOT NULL,

[DESCR] varchar(40) NOT NULL,

[SYNCFIELD] timestamp NOT NULL,

[ULTMOD] datetime NOT NULL,

[UTENTE] varchar(40) NOT NULL)

ON [PRIMARY]

WITH (DATA_COMPRESSION = NONE);

GO

ALTER TABLE [dbo].[CAUSALI_RAPPORTINI] SET (LOCK_ESCALATION = TABLE);

I stay tune for your answer.

Best regards,

Sergio

Hi,

Thank you! We create issue TSS-738 for this and discuss wether we will fix it.

Best Regards,

Bitter

Hi Bitter,

many thank’s for your support and answer.

I hope to see the problem solved for the next official release of TOAD SS.

There is an error of syntax to generate an insert statement.

From my point of view, If I use a tool to manage SQL Server DB and I can’t generate insert statement correctly, why must I to buy it ?

OK there are lots of others features in TOAD SS but the correct syntax of a statement is almost important.

What’s do you think of my idea ?

Best regards,

Sergio

You are not alone Segio. I have gone back to Toad 6.1

Hi tecNQ,

I’m agree with you. Last version of TOAD contains more bugs.

For now I still use 6.5 but I’m not so happy to use it…

I hope to see more problems solved in TOAD 6.6…

Best regards,

Sergio

Hi Bitter,

last beta of TOAD SS 6.6.0.371 and the problem still persist.

Best regards,

Sergio