Beautifier and multi tabl;e inserts

aotte

Member³
Hi,

Noticed that the beautifier strings all WHEN statements of a multi table insert statement onto a single line.

This piece of code...
Code:
INSERT ALL
   WHEN answer = 'Right' THEN
      INTO tbl_yes
   WHEN answer = 'Mwhoa' THEN
      INTO tbl_maybe
   WHEN answer = 'Not' THEN
      INTO tbl_no
   ELSE
      INTO tbl_who_knows
   SELECT *
   FROM tbl_question
   WHERE answered = 'Y';

...gets formatted to...
Code:
INSERT ALL WHEN answer = 'Right' THEN INTO tbl_yes WHEN answer = 'Mwhoa' THEN INTO tbl_maybe WHEN answer = 'Not' THEN INTO tbl_no ELSE INTO tbl_who_knows
   SELECT *
   FROM tbl_question
   WHERE answered = 'Y';

------------------
Hakuna Matata,

Arnoud.
 
Back
Top