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

From: Philippe Grosjean <phgrosjean_at_sciviews.org>
Date: Fri 18 Aug 2006 - 18:59:55 EST

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@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. Received on Fri Aug 18 19:04:27 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:51 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.