Displaying 1 result from an estimated 1 matches for "mstatement".
Did you mean:
statement
2004 Nov 02
2
A little more on R, mdbtools and Access databases
...rix(trim(tabDesc), ncol=3)
tabDesc <- data.frame(tabDesc)
names(tabDesc) <- c("ColumnName", "Type", "Size")
tabDesc$Size <- as.numeric(levels(tabDesc$Size)[tabDesc$Size])
system("rm -f tempR.sql")
tabDesc
}
mdbQuery <- function(dbname, mstatement, header=FALSE, footer=FALSE) {
cat(mstatement, "\ngo", file = "tempR.sql")
sqlOptions <- "-p"
if (!header) sqlOptions <- paste(sqlOptions, "H", sep="")
if (!footer) sqlOptions <- paste(sqlOptions, "F", sep="")...