[R] sqlSave()

cindy.dol cindy.dolomieu at insa-lyon.fr
Fri Jun 29 15:52:23 CEST 2012


Hello,

I have an issue with SqlUpdate and perhaps you can help me.
I have created a table with sqlSave. 
My table on Access is "PRT".
My dataframe on R : RESULTS.
My channel : C2.
sqlSave(C2, RESULTS, tablename = "PRT",rownames=FALSE, safer = FALSE)
And it works.

Now I would like to update it, to keep the old values and add new values.
I tried :
sqlUpdate(C2, RESULTS, tablename="PRT", append=TRUE) 
But it doesn't work, the error message is :"cannot update ‘PRT’ without
unique column"

Do you know how I can do it?



--
View this message in context: http://r.789695.n4.nabble.com/sqlSave-tp892040p4634881.html
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list