Thanks Dieter. The stored proc drops and recreates a result table that contains a copy of the same result set that is returned by the query.
If I pause after line 1, line 2 returns a valid result set and line 4 displays a table of data. If I do not pause the script after line 1 or 2, line 3 fails, saying datatable does not exist (line 1 query has not completed the recreation of datatable) and line 4 displays no data. Also, the query in line one returns a single result set, a select statement from datatable, but R doesn't see this returned result set after invocation of only line 1. 1.) dbdata<-sqlQuery(conn,"sp_GetData) #returns a result set in query analyzer, not in R 2.) head(dbdata) #it's empty 3.) dbdata<-sqlQuery(conn,"select * from datatable order by Date asc") 4.) head(dbdata) #the data is in dbdata My workaround is to run line 1's query manually before running any R scripts. Not ideal, but I'm at a loss for what else to try for this prickly case. Warm regards, Andrew Dieter Menne wrote: > > > > tradenet wrote: >> >> Thanks Dieter. >> >> The date argument isn't a problem. When I invoke the stored proc >> execution with the date arguments the stored proc runs fine, but RODBC >> doesn't wait for the stored proc to finish and return results. >> >> > > Don't understand that one. How do you know that is did not wait to finish? > > Did the call I showed you work with the Northwind database? > > Dieter > > -- View this message in context: http://www.nabble.com/RODBC-results-from-stored-procedure-tp24503096p24597208.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ 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.
