RJDBC: get number of rows inserted

Asked Nov 03 '18 at 19:47

Active Nov 04 '18 at 09:23

Viewed 89 times

How to get number of rows inserted or updated with RJDBC?
Example of such statement where I want get number of rows inserted:

conn <- RJDBC::JDBC(#params)
DBI::dbConnect(conn)
RJDBC::dbSendUpdate(conn, "insert into mytable values(1)")

I'm using MS SQL SERVER.

edited Nov 04 '18 at 09:23

asked Nov 03 '18 at 19:47

stakowerflol

Which database are you using? – Tim Biegeleisen Nov 03 '18 at 19:48
SQL SERVER. I have add it to my question :) – stakowerflol Nov 03 '18 at 19:52
For inserts, you should use `dbSendUpdate`. – Mark Rotteveel Nov 04 '18 at 09:16
yee, my typo. I have edited. – stakowerflol Nov 04 '18 at 09:23

0 Answers0