How can i update and insert new values in RSQlite?
I have a SQLite database which i want to fill using the RSQlite Interface. Some rows need to be updated and some rows need to be added. So using dbWriteTable() is neither sufficient with the option overwrite = TRUE nor with the option append = TRUE. What I tried instead is the following approach:
How can i update and insert new values in RSQlite?
I have a SQLite database which i want to fill using the RSQlite Interface. Some rows need to be updated and some rows need to be added. So using dbWriteTable() is neither sufficient with the option overwrite = TRUE nor with the option append = TRUE. What I tried instead is the following approach: