[R] function case in sqldf (datas from oracle) with a null value

I use sqldf to join 2 dataframes from 2 distinct databases : a and b come from old sqldf's. sqldf("select a.*, b.*, case a.QTY when null then b.QTY else a.QTY end as NEW_QTY" from a inner join b on a.OBJECT=b.OBJECT") R doesn't understand "when null". I tried with "when NA", "when '' ", "when '

[R] Compare date Oracle with Sys.time

I would like to import only datas of my table where DATE>today-7days. But my datas in Oracle are 'dates' and in R are 'characters'. now_7<-format(Sys.time()-(7*60*60*24), "%Y-%m-%d 00:00:00") How to do? -- View this message in context: http://r.789695.n4.nabble.com/Compare-date-Oracle-with-Sys-ti

[R] MS-DOS & script R

Hi, I would like to run R with a script from MS-DOS. R is in "My Documents "and my script too. How to do? -- View this message in context: http://r.789695.n4.nabble.com/MS-DOS-script-R-tp4635398.html Sent from the R help mailing list archive at Nabble.com. ___

Re: [R] sqlSave()

Julien Moeys: ok, I see what is the problem, Your example does not work because MS Access is trying to "update" values in your table according to the ID you provide So when you provide for instance ID = 1, MS Access will look in the table for an existing record(s) that have an ID of 1, and repla

[R] R with VBA_Excel

Do you know how can I run a script on R from Excel without rExcel but with VBA and batch? -- View this message in context: http://r.789695.n4.nabble.com/R-with-VBA-Excel-tp4635265.html Sent from the R help mailing list archive at Nabble.com. __ R-help@

Re: [R] sqlSave()

Hi, I tried your example but I have an error message: sqlUpdate( channel = con, dat = tbl, tablename = "myNewTable", index = "ID" ) *Erreur dans sqlUpdate(channel = con, dat = tbl, tablename = "myNewTable", : [RODBC] Failed exec in Update* I work with this: sessionInfo() R version 2.15.0 (20

Re: [R] sqlSave()

Hello, I have an issue with SqlUpdate and perhaps you can help me. I have created a table with sqlSave. My table on Access is "PRT". My dataframe on R : RESULTS. My channel : C2. sqlSave(C2, RESULTS, tablename = "PRT",rownames=FALSE, safer = FALSE) And it works. Now I would like to update it, to

[R] Update dataframe to Access without delete values

Hi! I created a table named "TEST2" in my base Access named "CINDY". My columns are : "A" (numeric), "B" (character), "C" (numeric) There are values in this table. In R, I created a data.frame fr: fr <- data.frame(A = c(1,2,3),B = c("c","d","u"), C=c(4,5,6)) I would like export this data.fra