[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