[Solved] select INTO from not formatted in a good way

8 Posts
2 Users
2 Likes
322 Views
(@radler64)
Member
Joined: 2 years ago
Posts: 12
Topic starter  

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


   
Quote
Guido
(@admin)
Member Admin
Joined: 2 years ago
Posts: 175
 

Hi Dieter,

thanks for your feedback. Very much appreciated. Please download the newest Release 6.22.10.04 and it should work now.

grafik

Regards

Guido


   
ReplyQuote
(@radler64)
Member
Joined: 2 years ago
Posts: 12
Topic starter  

@admin 

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


   
ReplyQuote
Guido
(@admin)
Member Admin
Joined: 2 years ago
Posts: 175
 

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

grafik

Regards

Guido

This post was modified 2 years ago by Guido

   
ReplyQuote
(@radler64)
Member
Joined: 2 years ago
Posts: 12
Topic starter  

@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


   
ReplyQuote
Guido
(@admin)
Member Admin
Joined: 2 years ago
Posts: 175
 

@radler64 Hi Dieter,

will update the DBeaver module soon (had to re-install my Computer from scratch)


   
radler64 reacted
ReplyQuote
Guido
(@admin)
Member Admin
Joined: 2 years ago
Posts: 175
 

@radler64 Hi Dieter,

the new relrease for DBeaver is ready for download

Regards

Guido


   
radler64 reacted
ReplyQuote
(@radler64)
Member
Joined: 2 years ago
Posts: 12
Topic starter  

Hi @admin,

thanks a lot. I installed this version and it looks absoulutely perfect now.

Cheers

Dieter


   
ReplyQuote
Share: