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.