[R] problem with looping on sqlSave()

Dieter Menne dieter.menne at menne-biomed.de
Thu Feb 25 10:24:38 CET 2010



Ivan Calandra wrote:
> 
> 
> I've tried it, but the problem is that each element has a different 
> size, with makes rbind() useless.
> 

Assuming that "size" means "different number of columns", then appending is
not valid, because it would change the structure of the table, and with ODBC
we are in the relational database world. In that case, you should assemble
your data frame with all possible columns and leave the fields empty.

If size means "different number of rows", where append DOES make sense, 
rbind is useful.

Dieter


-- 
View this message in context: http://n4.nabble.com/problem-with-looping-on-sqlSave-tp1567601p1568715.html
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list