Re: [R] RSqlite UPDATE command problem

2012-03-27 Thread Thomas Adams
Benilton, * * *Thank you — you are quite right!!* * * *Regards,* *Tom * On Tue, Mar 27, 2012 at 9:35 AM, Benilton Carvalho < beniltoncarva...@gmail.com> wrote: > You probably want: > > sql<-"UPDATE testtable SET vals=21 WHERE countries='NewZealand'" > dbGetQuery(con, sql) > > instead... > > b > >

Re: [R] RSqlite UPDATE command problem

2012-03-27 Thread Benilton Carvalho
You probably want: sql<-"UPDATE testtable SET vals=21 WHERE countries='NewZealand'" dbGetQuery(con, sql) instead... b On 27 March 2012 14:18, Thomas Adams wrote: > All: > > I am using RSqlite and want to be able to update individual values in a > record, such as with this simple example: > >

[R] RSqlite UPDATE command problem

2012-03-27 Thread Thomas Adams
All: I am using RSqlite and want to be able to update individual values in a record, such as with this simple example: library(RSQLite) drv<-dbDriver("SQLite") con<-dbConnect(drv,"test.db") my.data<-data.frame(countries=c("US","UK","Canada","Australia","NewZealand"),vals=c(52,36,74,10,98)) dbWrit