Best viewed in monospace font. Periods thrown in to prevent compression SELECT.T1.Column1, + .......t2.Column2 + ..FROM.Table1 t1, + .......Table2 t2 + .WHERE.t1.TablePKID=t2.TablePKID + ...AND.T2.Column3.=.'Humpty' + .ORDER BY t1.Column1
and such. Very readable during development. Bruce From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: Monday, March 17, 2014 3: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]
