Beautifier?

[ma]

Is it possible to establish in the beautifier something for the FROM and WHERE clauses? Selecting from mulitple tables and having mulitple joins run together and there doesn't seem to be a way to keep each on a separate line.

 

[Marco Kalter]

The format of the table list and field list is controlled by the "Select Items" on the "DML" tab page. You can set it to "One item per line".

------------------
Marco Kalter
Allround Automations

 

[ma]

That only formats the items in the SELECT statement, it does not seem to format the items in the FROM clause or in the WHERE clause. Also there is no control as to where the AND, IN , OR statements go within the WHERE clause.

 

[Marco Kalter]

It should have affected the table list. This is a bug that we will fix. You currently have no control over the positions of AND's and OR's in a condition. This will be added in a future release.

------------------
Marco Kalter
Allround Automations