I'm having a strange problem with dbWriteTable ... I have the dbWriteTable
inside a batchloop.
dbWriteTable(con,"mutual_funds",tmp_MF_Data_F,append=T,row.names=F) # append
rows to the data table
The data gets updated for the first 3 loops (out of say 100) but then there
is no error and data doesn't update.
The command is getting executed without a problem but the data does not get
updated in the database.
Any suggestions? I used debug I Revo and the dataframe that I am using to
update MySQL seems to be fine.
[[alternative HTML version deleted]]
______________________________________________
[email protected] 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.
