Displaying 1 result from an estimated 1 matches for "sqloptions".
Did you mean:
setoptions
2004 Nov 02
2
A little more on R, mdbtools and Access databases
..., "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="")
sqlStatement <- paste("mdb-sql", sqlOptions)
tmp <- read.table(pipe(paste(sqlStatement, &quo...