The GlobalIndent seems to have no effect
The IndentInPart does have an effect and indents the From parts a bit
Ideally in the future you want an indent for the subquery as a whole i.e everything between the brackets
SELECT F1,G2
FROM xyztable
Inner join .....
left join
-----(Select j1,y2
-----From
-----Where)
Where .... etc
Not urgent
Thanks for continuing to look at this.
I have tried your settings and although it changed the output the fundamental problem of things wrapping back to column 1 as explained above still remains
Whilst I would like this to work it is not as important to me when compared with the other two threads I replied to
Thanks again
Well, if you want to solve this problem, please send us a text file with full text of SQL query generated by Active Query Builder and a query text with desired formatting.
You can send it here. Hopefully you can attach it to your comment, can't you?
I can see insert video, picture and link but nothing for file ?
If I paste it in here it looses the formatting
I've taken some screen grabs and attached as pictures, I hope you can see them
The indenting doesn't have to be EXACTLY like the second picture BUT I don't want to see anything in column 1 other than Select, From and Where of the main outer query
Thanks
Current output
Desired output
ActiveQueryBuilderX.SQLFormatRightMargin - set it to zero. Menwhile I will check if wrapping could work in another way.
Thanks for this
As far as I am concerned this is fixed for now
Any improvements in the wrapping logic would be welcome but not vital
Please can you now comment on my other two threads
Thanks
FromNewLineAfterDatasource = false
FromNewLineAfterJoin = true
FromNewLineBeforeComma = false
FromNewLineBeforeJoinExpression = false
MainPartsFromNewLine = true
NewLineAfterPartKeywords = false
SelectNewLineAfterItem = false
SelectNewLineBeforeComma = false
IndentInParts = 2
IndentGlobal = 0
SQLFormatFrom.IndentGlobal = 8
Isn't it a configuration that suits your needs?