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: > >