I suggest replacing the R/SQL code with the following: ``` library("RSQLite") dbfile = "C:/Users/pfsmy/OneDrive/UoM/Carpentry/Datasets/SN7577.sqlite" mydb = dbConnect(drv = SQLite(), dbname=dbfile) results = dbGetQuery(mydb, "SELECT * FROM SN7577") dbDisconnect(mydb) ``` Using `dbGetQuery` is more straightforward and makes the code easier to read.
I suggest replacing the R/SQL code with the following:
Using
dbGetQueryis more straightforward and makes the code easier to read.