Hello,
I cannot find a way to format a SQL like:
select col1 , col2 INTO tablename from table2name it is allways converted to select col1 , col2 INTO tablename from table2name
Which is not a good thing if you have large lines and functions and ....
There is a linebreak option missing for INTO within a select (or at least I cannot find it).
Best regards
Dieter
Hello Guido,
thanks for your reply.
I know this option, I am using the latest version.
But this is an AFTER into linebreak.
What I am requesting is a BEFORE into linebreak.
Here is an (modified real live) example how it looks like when I am formatting one of our common sql:
, ga.Targetxxxxxxxxxxsart AS xxxxxxxxxxxxxxxx
, NULL AS RV_Contract INTO DATABASE.long_schema.themeA_AllContracts
FROM DATABASE.long_schema.themeA_Basis b
As you can see, the AFTER INTO linebreak sorts it at the end of a long line - where it is almost invisible.
My wish would be, to have it on the same level as the FROM clause.
Best regards
Dieter
@admin Hello Guido,
I am sorry, I did not have the latest version.
Now I have it and it looks fine in the Windows Gui.
I am also using DBeaver, and there I cannot get it to work in the same way as in the Windows GUI.
The INTO remains at the "old place".
My proces is:
- Save the profile
- Choose it for DBeaver
What shall I do more?
Thanks and best regards
Dieter
Hi @admin,
thanks a lot. I installed this version and it looks absoulutely perfect now.
Cheers
Dieter