update beautifier bug?

[Phil W]

Hi

I have set all options to break on new lines but the following statement refuses to budge the list of columns (at the *) into new lines. Does anyone know of a workaround please?

Phil

* update table set (col1,col2,col3,col4,col5)=
(select col1,
col2,
col3,
col4,
col5
from table2)
where col1=123;

 

[rbrooker]

i believe it is this way due to the brackets you are using. if you change it to : update table set col1 = col1, col2 = col2, col3 = col3 etc it will beautify as you want it to.

 

[petesmith]

Me too.

PL/SQL Developer 7.1.5.1398 doesn't beautify correlated update statements of this form correctly - The initial col1,col2,col3 etc. string doesn't get split at the commas.

I don't think such statements can be converted to the form that the previous poster suggests, and probably not in a readable form if it can.

In my situation the beautifier sticks the body of the UPDATE out at column 503 of the editor!

That said, the beautifier is the best feature of PL/SQL Developer.

Thanks,
Peter Smith.

 

[petesmith]

I've worked around my issue by placing a '--' and a manual line break wherever I want to force the beautifier to break the line.

The comment notation means that the beautifier cannot place anything after the '--' on the same line otherwise it will turn the code into a comment, so it has to line break.

 

[Phil W]

Any news on improving this? I Can't believe I raised it in 2005 and just did a search for a solution and it is still outstanding!

Phil