I am trying to use a shiny app to update records in an sqlite database. I keep
running into the following error:
unable to find an inherited method for function 'dbSendQuery' for
signature '"src_dbi", "character"'
The query I am trying to send is:
[1] "update kpquestions set mrisupercat = 'Demographics -
Respondent' , set mricategory = 'Respondent - Age' , where
VariableNumber = 2;"
Then I get this in my console window (and my browser connection to the locally
running shiny app closes - although the app remains listening on the port)
Warning: Error in <Anonymous>: unable to find an inherited method for
function 'dbSendQuery' for signature '"src_dbi",
"character"'
Stack trace (innermost first):
67: <Anonymous>
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
sessionInfo() results
R version 3.4.0 (2017-04-21)
Platform: x86_64-redhat-linux-gnu (64-bit)
Running under: Red Hat Enterprise Linux
Matrix products: default
BLAS/LAPACK: /usr/lib64/R/lib/libRblas.so
locale:
[1] LC_CTYPE=en_US.UTF-8 LC_NUMERIC=C LC_TIME=en_US.UTF-8
[4] LC_COLLATE=en_US.UTF-8 LC_MONETARY=en_US.UTF-8
LC_MESSAGES=en_US.UTF-8
[7] LC_PAPER=en_US.UTF-8 LC_NAME=C LC_ADDRESS=C
[10] LC_TELEPHONE=C LC_MEASUREMENT=en_US.UTF-8 LC_IDENTIFICATION=C
attached base packages:
[1] stats graphics grDevices utils datasets methods base
other attached packages:
[1] bindrcpp_0.2 shinydashboard_0.6.1 labelled_1.0.0 haven_1.1.0
[5] tidyr_0.6.3 dplyr_0.7.1 dbplyr_1.1.0 readr_1.1.1
[9] shiny_1.0.3 RSQLite_2.0
loaded via a namespace (and not attached):
[1] Rcpp_0.12.11 bindr_0.1 magrittr_1.5 hms_0.3
bit_1.1-12
[6] xtable_1.8-2 R6_2.2.2 rlang_0.1.1 blob_1.1.0
tools_3.4.0
[11] DBI_0.7 htmltools_0.3.6 bit64_0.9-7 assertthat_0.2.0
digest_0.6.12
[16] tibble_1.3.3 memoise_1.1.0 glue_1.1.1 mime_0.5
compiler_3.4.0
[21] forcats_0.2.0 jsonlite_1.5 httpuv_1.3.5 pkgconfig_2.0.1
>
Any help would be appreciated
--
W. Michael Conklin
Executive Vice President
Marketing & Data Sciences - North America
GfK | 8401 Golden Valley Road | Minneapolis | MN | 55427
mike.conklin at gfk.com<mailto:mike.conklin at gfk.com>
T +1 763 417 4545 | M +1 612 567 8287
www.gfk.com<http://www.gfk.com/>
[[alternative HTML version deleted]]
