[R] Maximum length of R GUI input line?

[Philippe Grosjean]

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