Hi,
I have a doubt regarding code indentation. It seems we can change the style of indentation according to us. I want clear view on it.
SELECT empname FROM employee WHERE empid=1
If I am using formatter it will indent as follows
SELECT empname
FROM employee
WHERE empid=1
But I want it to be happen as follows
SELECT
empname
FROM
employee
WHERE
empid=1
I came to know this can be done by formatter, but I don’t have idea about it.
So I am requesting you people to help for the above
Thanks,
MG Sai Chander
Email Id : mgsaichander17@gmail.com
Near the formatter options please select:
Alignments -> DML Statements -> Keywords LEFT aligned on own line
Hope this helps,
Andre
Hey [mention:5642d9e80729433eaed1dc5a8f2f2a12:e9ed411860ed4f2ba0265705b8793d05] , Thanks alot for answer. It helped me alot but i want help in certain areas like,
I want parameters to be in the next line with a tab space after JOIN statement also
SELECT
Empname,Empid,EmpSal
FROM
Emp_personalInfo per
JOIN
Emp_officalinfo off
ON
per.Empid = off.Empid
I want parameters to be on next line after parenthesis like
AND
(
Empid = 1
OR
(
Empid = 2
AND Empname = “Sai”
)
)
Is it possible. If so how?
Eagerly waiting for your reply… 
We did not design to wrap JOIN and ON clauses/subclauses on their own line the way you are showing, because they are subordinate to the FROM clause. Of course it could be done for this simple join, but then what if the join becomes more complex?
About the AND/OR, by selecting Stacked style in the AND-OR pane you can already get the following format:
AND (Empid = 1
OR (Empid = 2
AND Empname = "Sai"))
So I’d understand that you would require an option to lay out the parentheses differently, a little bit as was done near the List Arrangements, correct? This would then result in what you are suggesting.
Yes, [mention:5642d9e80729433eaed1dc5a8f2f2a12:e9ed411860ed4f2ba0265705b8793d05] You clearly understood what was i suppose to know.
May I know is it possible. If not may i expect this features in next version.
