[R-pkgs] eval() parse() and problem with square brackets
Jakub Jurdziak
enzo83 at wp.pl
Mon Jan 22 23:16:18 CET 2007
Hello,
i have problem with the following code (I'm using sqlQuery function from
RODBC package):
eval(parse(text="g_1 <- sqlQuery(cnn_1, \"select aa from
bb.[cc\\dd].ee\")")).
I get the error message:
"[RODBC] ERROR: Could not SQLExecDirect"
"S0002 208 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object
name 'bb.cc\dd.ee'."
It seems that R is replacing square brackets that are needed for
database to execute query.
How can I force R to change its behavior and leave square brackets
unchanged?
Any ideas appreciated
Kuba
More information about the R-packages
mailing list