I am using RODBC 1.1-2 with R 2.0.0 on a Debian box with a singel Pentium processor. My database is Informix 7.32. When I run a sql query I get the table header back but no data is selected. Please note this example:
Table "t1" has two columns, "a" and "b". The table is populated with three rows. Thi si the definition of the table: Column name Type Nulls a smallint yes b integer yes > sqlQuery(pricedb, "select * from t1") [1] a b <0 rows> (or 0-length row.names) > class(a$a) [1] "integer" > class(a$b) [1] "integer" using my C code on the same box, utalizing teh same odbc installation I get: 1 2 3 4 5 6 Does anyone have an idea why I get the table header but no data? Also, sqlTables() return no rows. > sqlTables(pricedb) [1] TABLE_QUALIFIER TABLE_OWNER TABLE_NAME TABLE_TYPE [5] REMARKS <0 rows> (or 0-length row.names) ______________________________________________ [EMAIL PROTECTED] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
