R help - Aug 2006 - Maximum length of R GUI input line?

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!

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)

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