WDSCi 7.0.0.4 (all updates applied)
From Preferences:
Automatic uppercasing is Custom, Keywords are Uppercase, Identifiers are Lowercase.
Automatic indent is on and set to 3 blanks.
Automatic formatting is on, New line on comma is End of line, New line on AND/OR keywords is After, On Case keyword is on.
Comments are Move to top.
Problem: It doesn't handle the JOIN and ON keywords the way I'd like.  Example:
       EXEC SQL
          INSERT INTO fip020a
             SELECT t2.f2cmpy, t1.f2styl, t1.f2clr, t1.f2size, t1.f2back,
                    t2.f2cust, ' ', 0, 0, 0, 0, 0, 0
                FROM fip020r t1 INNER JOIN fip020 t2 ON t1.f2styl = t2.f2styl
                   AND
                 t1.f2clr = t2.f2clr AND
                 t1.f2size = t2.f2size AND
                 t1.f2back = t2.f2back LEFT EXCEPTION JOIN fip020a t3 ON
                    t1.f2styl = t3.f2styl AND
                               t1.f2clr = t3.f2clr AND
                               t1.f2size = t3.f2size AND
                               t1.f2back = t3.f2back
                WHERE t1.f2cmpy = :wccmpy AND
                      t1.f2back = :wcback;
What I'd like to see:
       EXEC SQL
          INSERT INTO fip020a
             SELECT t2.f2cmpy, t1.f2styl, t1.f2clr, t1.f2size, t1.f2back,
                    t2.f2cust, ' ', 0, 0, 0, 0, 0, 0
                FROM fip020r t1 
                   INNER JOIN fip020 t2 ON 
                      t1.f2styl = t2.f2styl AND
                      t1.f2clr = t2.f2clr AND
                      t1.f2size = t2.f2size AND
                      t1.f2back = t2.f2back 
                   LEFT EXCEPTION JOIN fip020a t3 ON
                      t1.f2styl = t3.f2styl AND
                      t1.f2clr = t3.f2clr AND
                      t1.f2size = t3.f2size AND
                      t1.f2back = t3.f2back
                WHERE t1.f2cmpy = :wccmpy AND
                      t1.f2back = :wcback;
Is there any way to get it to do this now, or does it need to go on the 'wish list'?
Thanks!
Dave Shaw
Mohawk Industries
As an Amazon Associate we earn from qualifying purchases.