[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")
> # ....
> doMyRequest(MyQuery)

Indeed.  For the record, R has an limit of 1024 chars on input lines (from 
way back) and it cannot be altered.

> 
> Best,
> 
> 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
> 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.
> 

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