SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Can you customize your own format for SQL code formatting?

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Can you customize your own format for SQL code formatting?
Author Message
Hu



Joined: 08 Aug 2019
Posts: 8
Country: China

Post Can you customize your own format for SQL code formatting? Reply with quote
Can you customize your own format for SQL code formatting? JOIN and ON, for example, appear ON the same line

LEFT JOIN ORGANIZE B ON A.deptId = B.ID
Thu Aug 08, 2019 10:18 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
You can change that in the options. Please see the Code Formatting tab. Normally the pattern for JOINs is defined in the SELECT rules. But if you have it as a separate rul, then it would override the one inside SELECT


Thu Aug 08, 2019 11:27 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
Just in case. You may want to define multiple formatting styles using different formatting patterns for different styles. Having the entire join condition always on a single line might be problematic for multi-column joins and make the code difficult to read. The formatting style can be selected dynamically using Ctrl+Shift+F11.
Thu Aug 08, 2019 11:31 am View user's profile Send private message
Hu



Joined: 08 Aug 2019
Posts: 8
Country: China

Post very nice Reply with quote
Ok, thank you very much
Thu Aug 08, 2019 11:38 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.