Re: [R] RODBC Multiple Results

2020-03-30 Thread Law, Jason
: Wednesday, March 25, 2020 12:39 PM To: Doran, Harold Cc: r-help@r-project.org Subject: Re: [R] RODBC Multiple Results ⛔ The City's email systems have identified this email as potentially suspicious. Please click responsibly and be cautious if asked to provide sensitive information. You might wi

Re: [R] RODBC Multiple Results

2020-03-25 Thread Bert Gunter
You might wish to post this on r-sig-db if you do not get a satisfactory reply here. Also, have you checked the databases task view on : https://cran.r-project.org/ ? Bert Gunter "The trouble with having an open mind is that people keep coming along and sticking things into it." -- Opus (aka Ber

[R] RODBC Multiple Results

2020-03-25 Thread Doran, Harold
I'm calling a stored procedure that returns multiple tables and my current framework uses RODBC and sqlQuery() to communicate between R and the databases we connect to. A new stored procedure returns multiple tables and I found this on SO indicating that RODBC "may not" be able to retrieve multi