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
Ah OK yes I can now see setting SQLFormatFrom to say 10 gives me almost what I want
It appears that the problem is whatever logic is used to split the Join lines (Inner Join etc) does not honour this indent for the sub query
So you end up with the select and columns indented by x spaces but when it gets to wrapping a Join line for the subquery it is wrapped to coliumn 1 and not under the I of Inner Join
Hope that makes sense
Use the ActiveQueryBuilderX.SQLFormatFrom.IndentGlobal to format the query the way you need.
There are four sets of formatting options:
Yes this IndentGlobal now works, thanks .... it was a bug ..... it now indents the whole query ..... but it wasn't really the problem I wanted solving .....
Not urgent but it would make things more readable
Hello,
Is this in the latest release notes related to this thread or something else ?
The error with quotation of sub-query text in the cells of Select List
Control is fixed.
There are four properties of the ISQLBuilderSelectFormat to set new lines after any token of the FROM clause, try to play with them: