[R] RODBC query on one line

Sean Davis sdavis2 at mail.nih.gov
Wed Sep 1 12:08:35 CEST 2004

I often use paste to build up SQL queries into line-sized chunks, but 
this is only a convenience and not required.  It does improve 
readability and maintainability, in my opinion.


On Sep 1, 2004, at 5:09 AM, Mikkel Grum wrote:

> Dear R-helpers,
> When I use sqlQuery in the package RODBC, I cannot
> break the line, but have to write the entire SQL Query
> on the same line.  Is this expected behaviour? It is
> definitely workable, but makes the queries a slightly
> difficult to read and edit.
> I'm using R 1.9.1 and RODBC 1.0-4 on Windows Server
> 2003 and querying a Sybase database.
> Best wishes,
> Mikkel
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! 
> http://www.R-project.org/posting-guide.html

More information about the R-help mailing list