SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[11.3.279 Pro] - Questions: formatting of the inserted code

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[11.3.279 Pro] - Questions: formatting of the inserted code
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2108

Post [11.3.279 Pro] - Questions: formatting of the inserted code Reply with quote
In this video here you can see me typing INNER JOIN and then selecting a table from the list of possible candidates in the popup.

My questions are:

#1 What determines the formatting of the inserted code fragment?
#2 Why is it inserted broken into two lines?
Wed Dec 16, 2020 8:23 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Reply with quote
I think it's hardwired into Intellisense, it's like

Code:
... JOIN table clause
        ON column condition 1...  [AND column condition 2... depending on number of columns in the foreign key]


The result can be reformatted using formatting rules.

This behavior of JOINs is a bit changing in the upcoming maintenance release, there are going to be more options for which parts of join to insert, with or without columns, one at a time, or all together, etc...
Mon Dec 21, 2020 6:01 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2108

Post Reply with quote
That sounds great! Will there be an option not to break the code into multiple lines? Have you got an ETA for that release? (disregard that last question, I've seen the ETA in another topic, thanks for the info).
Mon Dec 21, 2020 6:20 pm 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.