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]]

