SQLite: Difference between revisions

SQLite (view source)

122 bytes removed , 4 years ago

Bureaucrats, cc_docs_admin, cc_staff

2,318

edits

@@ Line 40: / Line 40: @@
 # after which you can use code like the following to interact with the SQLite database
 library(DBI)
+age <- 34
+query <- ""
 # Connect to the database...
@@ Line 45: / Line 48: @@
 # A parameterized query
-rs <- dbSendQuery(dbase,"SELECT * FROM tname",params = list(tname = "employees"))
+paste(c("INSERT INTO employee(name,age) VALUES(\"John Smith\",",toString(age),");",query),collapse='')
-while (!dbHasCompleted(rs)) {
+ierr <- dbExecute(dbase,query)
-  # Grab a maximum of ten rows at a time...
-  df <- dbFetch(rs,n = 10)
-  # Print the number of rows we actually got from dbFetch
-  print(nrow(df))
-}
-dbClearResult(rs)
 # Close the database connection