Thanks. But if I do as you suggested... txt<-'SELECT Date, Region, Price FROM TableXYZ WHERE Type="Domestic"'
returns... "SELECT TradeDate, Hub, SettlementPrice FROM PowerSettlements WHERE Contract=\"ERN\"" Which because of the extra "\"' is improper SQL form. Maybe I should be asking what is the proper way to return "" inside of a char string? -----Original Message----- From: Uwe Ligges [mailto:lig...@statistik.tu-dortmund.de] Sent: Tuesday, December 20, 2011 8:46 AM To: Mike Pfeiff Cc: 'r-help@r-project.org' Subject: Re: [R] RODBC Error: 'getCharCE' must be called on a CHARSXP On 20.12.2011 14:55, Mike Pfeiff wrote: > I am trying to connect to an internal database and use the sqlQuery command > to reduce and retrieve data using the following code: > > channel<-odbcConnect("some_dsn", uid="", pwd="") txt<-'SELECT Date, > Region, Price FROM TableXYZ WHERE Type="Domestic"' > sqlQuery(channel, cat(txt,"\n"),errors=TRUE,) sqlQuery(channel, txt, errors=TRUE) seems more plausible (since cat returns NULL). Uwe Ligges > close(channel) > > However, I get the following error immediately after sqlQuery command: > > Error in odbcQuery(channel, query, rows_at_time) : > 'getCharCE' must be called on a CHARSXP > > I believe my connection is good because I used the following commands to > successfully view the columns: > > sqlColumns(channel, TableXYZ) > > There doesn't seem to be much info on "getCharCE" and/or "CHARSXP. > Any guidance the group could provide this vey new user to R, would be > greatly appreciated > > > > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@r-project.org 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@r-project.org 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.