This is pretty close to what I do; however, I also place columns in
individual lines.
It comes handy with commands such as:
INSERT INTO my_tableA +
Col_1, +
Col_2, +
Col_3 +
SELECT +
Col_A, +
Col_B, +
Col_C +
FROM my_tableB
And you have 50 or 60 columns to match; having them in separate lines makes
it easier to verify the assignments.
Javier,
Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137
From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall
Sent: Monday, March 17, 2014 5:37 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: R:STYLE TIP
I can't live without "Mixed Double Indenting." It indents clauses of
SELECT, etc. based on certain key words. For example
select +
columna, columnb, columnc, +
sum (columnD), max (ColumnE) +
from +
table1 a1, table2 b2, table3 c3 +
where a1.akeycol = b2.afkcol +
and b2.bkeycol = c3.bfkcol +
and a1.zipcode = .vZipCode +
group by columna, columnb, columnc +
having sum (columnD) > 0 +
and max (columnE) > '1/1/2014'
Can turn into:
SELECT +
columnA, columnB, columnC, +
SUM (columnD), MAX (ColumnE) +
FROM +
Table1 a1, Table2 b2, Table3 c3 +
WHERE a1.aKeyCol = b2.aFKCol +
AND b2.bKeyCol = c3.bFKCol +
AND a1.ZipCode = .vZipCode +
GROUP BY columnA, columnB, columnC +
HAVING SUM (columnD) > 0 +
AND MAX (columnE) > '1/1/2014'
Bill
On Mon, Mar 17, 2014 at 6:03 PM, James Bentley <[email protected]>
wrote:
Perhaps a discussion of how we would like RStyle to
reformat lines is in order. I for one would like the
smart code wrapping to break on additional key words
since with nested joins it would help to better
highlight the joins.
Jim Bentley,
American Celiac Society
1-504-737-3293Perhaps
_____
From: Javier Valencia <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Monday, March 17, 2014 2:34 PM
Subject: [RBASE-L] - RE: R:STYLE TIP
This is good to now.
I have also seen this; sometimes R:style changes the way I structure lines
and makes it less readable.
Javier,
Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137
From: [email protected] [mailto:[email protected]] On Behalf Of Dennis
McGrath
Sent: Monday, March 17, 2014 2:29 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - R:STYLE TIP
I've had more than one person tell me they stopped using R:Style because it
did not wrap lines consistently the way they want.
They really missed the other features, especially the way it catches many of
their errors.
I was starting to feel the same issue.
Answer is to set the "Smart Code Wrapping" combo to "disabled"
All the other features still work, but code lines are never reorganized.
Virtually all of R:Style's features can be turned off, if they get in your
way.
Dennis McGrath
Software Developer
QMI Security Solutions
1661 Glenlake Ave
Itasca IL 60143
630-980-8461
[email protected]
