Displaying 1 result from an estimated 1 matches for "tblindexweekly".
2009 Jan 26
2
R crashes when using the RODBC Package
...RUE)
# Get Weightings
sql <- "SELECT BbSecurity, Weighting FROM qryWeightingsUse"
sWeights <- sqlQuery(channel, sql)
# ==== Copy Data to Database ====
if ( bWeekly ) {
tblName <- "tblIndexWeekly"
} else {
tblName <- "tblIndexMonthly"
}
sqlQuery(channel, paste("DELETE * FROM ", tblName))
sqlSave(channel, indexDf, tablename = tblName, append=TRUE,
rownames=FALSE)
}
odbcClose(chan...