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]
>
>
>
