Re: [R] Maximum length of R GUI input line?

From: Prof Brian Ripley <ripley_at_stats.ox.ac.uk>
Date: Fri 18 Aug 2006 - 19:15:36 EST

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

______________________________________________
R-help@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.
Received on Fri Aug 18 19:20:55 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Fri 18 Aug 2006 - 20:19:59 EST.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.