[R] RODBC query on one line

Prof Brian Ripley ripley at stats.ox.ac.uk
Wed Sep 1 11:49:47 CEST 2004

Not true: you have to submit the query as one element of a character
vector, not the same thing at all.  You *can* use paste() to assemble it.

On Wed, 1 Sep 2004, 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.

Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

More information about the R-help mailing list