Re: [R] RODBC: sqlUpdate doesn't handle properly POSIXct field?

2011-08-28 Thread WanderingWizard
Thanks a bunch, it was driving me nuts. My experience would seem to confirm yours. Thanks to your post, I fixed a database update that was crashing my R session. I changed the data column that I was posting from a POSIXct to a Date, and now the data goes in. That works fine for me since my data

Re: [R] RODBC: sqlUpdate doesn't handle properly POSIXct field?

2011-08-07 Thread Mikhail Titov
project.org [mailto:r-help-boun...@r-project.org] On > Behalf Of Mikhail Titov > Sent: Sunday, August 07, 2011 7:27 PM > To: r-help@r-project.org > Subject: Re: [R] RODBC: sqlUpdate doesn't handle properly POSIXct field? > > I apologize for the first e-mail as I didn't use

Re: [R] RODBC: sqlUpdate doesn't handle properly POSIXct field?

2011-08-07 Thread Mikhail Titov
org] On > Behalf Of Mikhail Titov > Sent: Sunday, August 07, 2011 7:22 PM > To: r-help@r-project.org > Subject: [R] RODBC: sqlUpdate doesn't handle properly POSIXct field? > > Hello all! > > > > Can someone confirm whether there is a bug or not? > >

[R] RODBC: sqlUpdate doesn't handle properly POSIXct field?

2011-08-07 Thread Mikhail Titov
Hello all! Can someone confirm whether there is a bug or not? I was trying to use sqlUpdate in place of sqlSave as data set I import has duplications. However I get errors while using fast=FALSE argument to safely update/ignore duplicates: Error while executing the query[RODBC] ERROR: