SQLinForm SQL Formatter
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
Hi Dieter,
thanks for your feedback. Very much appreciated. Please download the newest Release 6.22.10.04 and it should work now.
Regards
Guido
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
Hi Dieter,
are you using Release 6.22.10.04 (published yesterday)?
When downloading the new release please delete your browser's cache.
There is no option for linebreaks before INTO. It is a default
Regards
Guido
@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
@radler64 Hi Dieter,
will update the DBeaver module soon (had to re-install my Computer from scratch)
Hi @admin,
thanks a lot. I installed this version and it looks absoulutely perfect now.
Cheers
Dieter
