[R] RODBC query on one line

Mikkel Grum mi2kelgrum at yahoo.com
Wed Sep 1 14:00:40 CEST 2004


Thanks Brian and Sean,

Works well and solves another problem I had: changing
the same condition in a series of related but
different queries, by making only one change in a
variable that is then used in all the queries.

Mikkel

--- Sean Davis <sdavis2 at mail.nih.gov> wrote:

> 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.
> 
> Sean
> 
> 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