Re: [R] sqlSave, fast=F option, bug?

From: Dieter Menne <dieter.menne_at_menne-biomed.de>
Date: Wed 18 Oct 2006 - 15:06:01 GMT

Paul MacManus <paul.macmanus <at> gmail.com> writes:

> Using the fast=F option, sqlSave saves without matching column names.
> It looks like a bug to me..........
....
> In other words, sqlSave didn't check column names, it simply mapped
> column 1 to column 1 and column 2 to column 2.

This seems to be a problem with SQLServer. The following example with Access works correctly for me, even if I close the connection in between. (Win2k, R 2.4.0)

Dieter Menne



library(RODBC)
channel <- odbcConnectAccess("db1.mdb")
df <- data.frame(T=1, S=10)
sqlSave(channel, df, "test", rownames=F) #odbcClose(channel)

#channel <- odbcConnectAccess("db1.mdb") df <- data.frame(S=20, T=2)
sqlSave(channel, df, "test", rownames=F, append=T,fast=T) odbcClose(channel)



R-help@stat.math.ethz.ch 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. Received on Thu Oct 19 01:25:49 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Thu 19 Oct 2006 - 01:30:11 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.