Displaying 1 result from an estimated 1 matches for "stmnt".
Did you mean:
stent
2017 Jul 17
0
dbplyr error updating database
...66: dbSendQuery
65: observeEventHandler [/home/mconklin/tmpdir/CodeKPVars/server.R#76]
1: runApp
Auto-disconnecting SQLiteConnection
Auto-disconnecting SQLiteConnection
The specific chunk of server code being run is:
kpnew<-src_sqlite("/var/sqlite/KPProfile2")
stmnt<-paste0("update kpquestions set mrisupercat = '",input$supercat,"' , set mricategory = '",input$subcat, "' , where VariableNumber = ",input$vnum, ";")
print(stmnt)
dbSendQuery(kpnew,stmnt)
the print(stmnt) can be read above
s...