[R] Maximum length of R GUI input line?
Prof Brian Ripley
ripley at stats.ox.ac.uk
Fri Aug 18 11:15:36 CEST 2006
On Fri, 18 Aug 2006, Philippe Grosjean wrote:
> You should put your SQL query in a variable, and use this variable in
> your call. Something like:
> MyQuery <- "bla bla bla"
> MyQuery <- paste(MyQuery, "more bla bla")
> # ....
Indeed. For the record, R has an limit of 1024 chars on input lines (from
way back) and it cannot be altered.
> Philippe Grosjean
> Eric Fegraus wrote:
> > Hello,
> > I'm using R 2.3.1 on Windows.
> > I'm generating some very long SQL statements. I do this by using
> > paste() which will contain many strings and variables. I'm getting an
> > error when the the total line length is longer than about 1013
> > characters. For example, it works with the line containing 1013
> > characters and not when it is 1059.
> > I've looked into adjusting the options(width) and a handful of other
> > settings. I have a feeling there is some other setting i'm missing
> > that i can adjust.
> > Any ideas?
> > Thanks!
> > ______________________________________________
> > 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
> > and provide commented, minimal, self-contained, reproducible code.
> R-help at stat.math.ethz.ch mailing list
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
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