[R] [R-pkgs] eval() parse() and problem with square brackets

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

[R] eval() parse() and problem with square brackets

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

Re: [R] eval() parse() and problem with square brackets

Hi, unfortunately I'm not able to check how it behaves at the moment. Even if it works ok, it is impossible to drop eval and parse in my situation. I’m using RExcel and RInterface.RRun to execute code from the string: g_1 - sqlQuery(cnn_1, select aa from bb.[cc\\dd].ee). RExcel adds eval and

Re: [R] eval() parse() and problem with square brackets

RExcel and R (D)COM Server together allow you to write R commands in Excel, execute them in hidden instance of R and get results back to Excel. For more details - see http://sunsite.univie.ac.at/rcom/. The problem I have arises because R commands written in Excel are transformed before