Displaying 1 result from an estimated 1 matches for "rnameodbccolumns".
2000 Mar 08
0
RODBC: follow up
...) in sqltablecreate
gsub("[^A-Za-z]+", "", as.character(coldata[i, 4]))
destroys numbers in column names, rather use
gsub("[^A-Za-z0-9]+", "", as.character(coldata[i, 4]))
Furthermore think about substituting '_' in SQLNAMES to '.' in
RNAMEodbcColumns(channel, table)S and vice versa.
gsub("[.]", "_", RNAME)
gsub("[_]", ".", SQLNAME)
(5) in several functions you use
if (!any(sqlTables(channel) == sqtable)) )
shouldn't that read
if (!any(sqlTables(channel)[4] == sqtable))
?
The above menti...