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
>
> On 27 March 2012 14:18, Thomas Adams <thomas.ad...@noaa.gov> wrote:
>
>> 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))
>> dbWriteTable(con,"testtable",my.data)
>> q<-dbReadTable(con,"testtable")
>> q
>>
>> countries vals
>> 1 US 52
>> 2 UK 36
>> 3 Canada 74
>> 4 Australia 10
>> 5 NewZealand 98
>>
>> So, say, I want to change the value for NewZealand to '21' from '98'
>>
>> I've tried something like this:
>>
>> sql<-"UPDATE testtable SET vals=21 WHERE countries='NewZealand'"
>> dbBeginTransaction(con)
>> dbGetPreparedQuery(con,sql) <========== I get an error here
>> dbCommit(con)
>>
>> using a different example for an INSERT command using a data frame 'data',
>> this construct is accepted:
>>
>> dbGetPreparedQuery(con,sql,bind.data=data)
>>
>> What do I need to do differently to use the UPDATE command?
>>
>> Regards,
>> Tom
>>
>>
>> --
>>
>> Thomas E Adams
>> National Weather Service
>> Ohio River Forecast Center
>> 1901 South State Route 134
>> Wilmington, OH 45177
>>
>> EMAIL: thomas.ad...@noaa.gov
>> VOICE: 937-383-0528
>> FAX: 937-383-0033
>>
>> [[alternative HTML version deleted]]
>>
>> ______________________________________________
>> R-help@r-project.org mailing list
>> https://stat.ethz.ch/mailman/listinfo/r-help
>> PLEASE do read the posting guide
>> http://www.R-project.org/posting-guide.html
>> and provide commented, minimal, self-contained, reproducible code.
>>
>
>
--
Thomas E Adams
National Weather Service
Ohio River Forecast Center
1901 South State Route 134
Wilmington, OH 45177
EMAIL: thomas.ad...@noaa.gov
VOICE: 937-383-0528
FAX: 937-383-0033
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
