Toad World® Forums

Formatter issues

#1

hi

(I know its another developer team and that will not be solved for the nexts releases)

FUNCTION xpto
/* Give some description
Raises exception bla when bla
*/
(pi_var in integer)
return varchar2

Formatting gets:

FUNCTION xpto/* Give some description
                 Raises exception bla when bla
            */
(pi_var IN INTEGER)
    RETURN VARCHAR2

Its annoying that changes the commentary (the starting line and tabs in other lines)

with advice 511 triggered
FUNCTION xpto /* Give some description
/*ADVICE(3): Function does not contain a RETURN statement [511] */
Raises exception bla when bla
*/
(pi_var IN INTEGER)
RETURN VARCHAR2

The code will not compile due that the comentary was “cutted”

Regards
Filipe Silva

#2

Hi Filipe,

Thanks for reporting. This is basically caused by the block comment moving to the preceding line. The comment should not change its place. There’s an existing CR for this. I will let you know once it’s done.

Thanks,
Vincent

#3

I just installed the latest version of TOAD for SQL Server (6.5.0.3001). and ran into this problem. There hasn’t been a fix since this was reported in 2010?

#4

Hi Freeman,

You could have posed any question about "TOAD for SQL Server " in the Toad for SQL Server Community , and someone will answer for you, the Toad for SQL Server Community link is:

www.toadworld.com/…/default.aspx

Thanks and Regads,

Alan

#5

I’m going to get this issue fixed next job (QP-901). It may have been fixed before but not in a stable way.

Andre