To reproduce:
#app.R
library(shiny)
library(RODBC)
savefunc <- function() {
conn <- odbcConnect(...) #put in a conn string u know works
df = data.frame(testing=c("testing"))
columnTypes = list(testing="varchar(128)")
tryCatch(
{
sqlSave(conn, dat=df, tablename ="...", #put in a pre-existing tbl
rownames = FALSE, colnames = FALSE, append=TRUE, varTypes=columnTypes)
},
err=function(errorCondition) {
cat("in err handler")
message(errorCondition)
},
warn=function(warningCondition) {
cat("in warn handler")
message(warningCondition)
},
finally={
odbcClose(conn)
}
)
}
server <- function(input, output) {
observeEvent(input$doBtn, {
savefunc()
})
}
ui <- shinyUI(fluidPage(
mainPanel(
actionButton("doBtn", "Do something")
)
))
shinyApp(ui = ui, server = server)
#app.R
library(shiny)
library(R