Hello,

I created a table in MySQL with this command

CREATE TABLE example (pk INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(pk),
 id VARCHAR(30),col1 VARCHAR(30),col2 VARCHAR(30))

### In R, I can connect to this table:

library(DBI)
library(RODBC)
chan <- odbcConnect("MySQL51", uid="root", pwd="xxx") 
first <- sqlQuery(chan, "select * from example")
close(chan)
First
#[1] pk   id   col1 col2
#<0 rows> (or 0-length row.names)

### This is the table I'm trying to save:
dframe <-data.frame(matrix(1:6,2,3))
colnames(dframe)=c("id","col1","col2")
dframe
#  id col1 col2
#1  1    3    5
#2  2    4    6

### But this makes Rgui crash and close
chan <- odbcConnect("MySQL51", uid="root", pwd="xxx")  
sqlSave(chan, dframe, tablename="example", rownames = FALSE, append=T)
close(chan)

### With rownames = T and safer=F, it works, but I loose the
autoincrementing PK in MySQL
chan <- odbcConnect("MySQL51", uid="root", pwd="momie")  #default
database=fbn
sqlSave(chan, dframe, tablename="example", rownames = T,
addPK=T,append=T,safer=F)
close(chan)

Any idea?

I'm on win2K, MySQL version 5.0.21-community-nt
> version
               _                                        
platform       i386-pc-mingw32                          
arch           i386                                     
os             mingw32                                  
system         i386, mingw32                            
status         Patched                                  
major          2                                        
minor          3.0                                      
year           2006                                     
month          05                                       
day            11                                       
svn rev        38024                                    
language       R                                        
version.string Version 2.3.0 Patched (2006-05-11 r38024)

Pierre Lapointe


**************************************************
AVIS DE NON-RESPONSABILITE: Ce document transmis par courrie...{{dropped}}

