Update table using RODBC and DT

shiny
1

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({
    input$refreshTable
    sqlcmd <- paste("select
            *
           from ", input$selected_database,".",input$selected_table)
    odbcQuery(conn, sqlcmd)
    sqlGetResults(conn)
})

output$referenceTable <- renderDT(
    referenceTable(),
    editable = TRUE
)
2

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