beautifier

[JohnnyBeGood]

In the dml section of the beautifier option it would be nice if we could put the keyword "and" on a new line

If I applied the beautifier on this (all on the same line)

select * from pilo_tbl_utilsn_spec utsp where utsp.atgl_id_spec = 1 and utsp.vaat_id = 3

I get

select *
from pilo_tbl_utilsn_spec utsp
where utsp.atgl_id_spec = 1 and utsp.vaat_id = 3

but what I want is

select *
from pilo_tbl_utilsn_spec utsp
where utsp.atgl_id_spec = 1
and utsp.vaat_id = 3

is it possible ?

Thanks

Jean Boul

 

[roselan]

It is already a feature request, but then I would like that: (i replaced "spaces" by "underscores", are multiple spaces are automatically trimmed in this forum).

select_*
from___pilo_tbl_utilsn_spec_utsp
where__utsp.atgl_id_spec_=_1
and____utsp.vaat_id______= 3

regards

[This message has been edited by roselan (edited 30 July 2003).]

[This message has been edited by roselan (edited 30 July 2003).]

 

[TenGor]

Hy,

it would be nice, if the beautifier can also handle a select format like this:
(i replaced "spaces" by "underscores" too)

SELECT_id
__INTO_var_id
__FROM_table
_WHERE_id_=_42
___AND_id_>_2
_ORDER_BY_id

Perhaps it is possible to develop a "format mask" for those statements?

--
Thanks for helping
TenGor

 

[Marco Kalter]

The only thing that is not yet supported in these 3 examples is the formatting of the conditions. This is on our to-do list.

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

 

[TenGor]

Thanks in advance
TenGor