Displaying 1 result from an estimated 1 matches for "table_list".
Did you mean:
pgtable_list
2006 Apr 01
4
-newbie | RODBC import query
...;TEST': table not found on channel
OK - so it doesn't seem to find the table TEST in test.dbf. I tried
lower-case for TEST (i.e., test), but that doesn't seem to solve the
problem. OK, so lets pretend I don't know what the table in test.dbf
is called, and use sqlTables instead:
table_list <- sqlTables(import_dat)
When I then enter table_list in the console, I get
[1] TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS
<0 rows> (or 0-length row.names)
Meaning, what? It almost seems that its telling me there is nothing
in test.dbf. Well, there definitely is (I can ope...