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
I am just confused by the eval parse \ and such.
what happens if simplify to :
g_1 - sqlQuery(cnn_1, select aa from bb.[cc\\dd].ee)
how would the query look in a native sql program?
Cheers,
Kees
On Tuesday 23 January 2007 17:29, Jakub Jurdziak wrote:
Hello,
i have problem with the following
If the question is how to represent a character string containing double
quotes without using \ then just use single quotes for the entire string
instead:
'He said dog and she said cat.'
On 1/23/07, chao gai [EMAIL PROTECTED] wrote:
I am just confused by the eval parse \ and such.
what happens
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
Jakub,
I was trying to simplify the situation in order to know where the fault
happens.
Appearently, from Excel, you go to R, which does some query in an MS
application ? The square brackets now make me think that is Excel again, but
I do not know.
Had I known that I would not have touched
Jakub Jurdziak wrote:
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
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