 |
SoftTree Technologies
Technical Support Forums
|
|
| Author |
Message |
Hu
Joined: 08 Aug 2019
Posts: 8
Country: China |
|
 Can you customize your own format for SQL code formatting? |
 |
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 |
  |
 |
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
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 |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
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 |
|
|
Hu
Joined: 08 Aug 2019
Posts: 8
Country: China |
|
| very nice |
|
Ok, thank you very much
|
|
| Thu Aug 08, 2019 11:38 am |
|
|
|
|
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
|
|
|
