Toad World® Forums

bug: procedure


#1

Bug report:

Create a stored procedure using the toad execution statement, if the last parameter has an empty string default and a multi line comment command is created, the default value and comment will be lost.

For example:

step1: Execute the following statement in toad,

create PROCEDURE [dbo].[proc_errortest]
@xx varchar(1)=’’ /the default value will be lost, and the comment will be lost/
AS
select 1

step2:review the definition of the procedure proc_errortest, the result is:

create PROCEDURE [dbo].[proc_errortest]
@xx varchar(1)
AS
select 1
GO


#2

Hi weiwsy,

I try to execute your execution statement in the last beta of TOAD SS 6.7.0.37 and the problem/bug is present too.

Best regards,

Sergio


#3

When will fix this bug?


#4

Hi, Sergio

Thank you for your reply, are you the official staff?

do you know when an official can do to fix this problem


#5

Hi Weiwsy,

nothing. I’m not member of the official staff.

I don’t know if and when toad’s developers think to solved the problem.

Kelly or Cathy, can you reply to Weiwsy about this problem ?

Best regards,

Sergio


#6

Hi,

I put this issue in our fixed plan(TSS-1222). We will try to fix soon.

Kelly