dbListFields dosen't work for temporary tables

agstudy / rsqlserver

Sql Server driver database interface (DBI) driver for R. This is a DBI-compliant Sql Server driver based on the System.Data.SqlClient.

82 stars 30 forks source link

Closed hs3180 closed 9 years ago

hs3180 commented 10 years ago

dbListFields returns character(0) for temporary table input.

agstudy commented 9 years ago

The #temp tables are specifically only for the current connection that created them.

So it is normal that you can not see them , using dbListFields or even dbListTables that use a new connection.