Toad World® Forums

Formatter issues

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

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

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?

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

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