Update table using RODBC and DT

I am using RODBC to retrieve data from a reference table and then using the DT package to render the table with editable = TRUE. Once the value(s) have been updated, I want to use an actionButton to write the changd values back to the database. What are some methods that can be used?

referenceTable <- reactive({
    sqlcmd <- paste("select
           from ", input$selected_database,".",input$selected_table)
    odbcQuery(conn, sqlcmd)

output$referenceTable <- renderDT(
    editable = TRUE

This topic was automatically closed 54 days after the last reply. New replies are no longer allowed.