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.
