search for: odbcprimarykey

Displaying 2 results from an estimated 2 matches for "odbcprimarykey".

Did you mean: odbcprimarykeys
2009 Feb 24
0
RODBC connectivity
I am using R to access .mdb files (created in Microsoft access 2003)  through RODBC. I am able to view the Tables and also list their attributes through the sql............. commands. However, when try to acces the primary keys (using sqlPrimaryKeys /odbcPrimaryKeys) I get a value of  '-1' on my command line, i.e. I am unable to identify the PrimaryKeys in the Tables. Any suggestions why this would happen. [[alternative HTML version deleted]]
2000 Mar 08
0
RODBC: follow up
Hi Michael, Here is the result of my first testing: (0) Dr. Watson Sorry, I should have given a more precise description: by default in R exists a function with the name 'table', if you use this name as in odbcPrimaryKeys(0, table) a Dr. Watson occurs, because table does not give a table name. However, it is always a good idea to prevent Dr. Watsons, even if it is triggered by a stupid user, as in my case. (1, may be Davids comment already solves this?) There are still some problems with sqlTables() and sqlQuery...