search for: extfuns

RSQLite.extfuns provides SQLite extension functions for use with RSQLite. The package is a wrapper of extension functions written by Liam Healy and made available through the SQLite website (http://www.sqlite.org/contrib). You can make the extension functions available on a per db connection basis like this: li...

RSQLite.extfuns provides SQLite extension functions for use with RSQLite. The package is a wrapper of extension functions written by Liam Healy and made available through the SQLite website (http://www.sqlite.org/contrib). You can make the extension functions available on a per db connection basis like this: li...

...em on my Windows machine. Here is what happens: > r=sqldf("select ... ") Loading required package: tcltk Loading Tcl/Tk interface ... Then it never loads. I have X11 open. I have all the latest versions of all the necessary packages for sqldf 0.3-5: DBI 0.2-5 RSQLite 0.9-1 RSQLite.extfuns 0.0.1 gsubfn 0.5-3 proto 0.3-8 chron 2.3-35 Although it gives warning messages for these: package 'sqldf' was built under R version 2.11.1 package 'RSQLite' was built under R version 2.11.1 package 'RSQLite.extfuns' was built under R version 2.11.1 package 'gsubfun'...

...long script that runs fine on windows (32 bit). When I try to run in on two different macs (64 bit), however, it hangs with identical behavior. I start with: library(sqldf) This results in messages: Loading required package: DBI Loading required package: RSQLite Loading required package: RSQLite.extfuns Loading required package: gsubfn Loading required package: proto Loading required package: chron I then read some data, etc. I execute the following: #merge raw data and all possible combinations df.final <- sqldf('select Date, Hour, x as RoomsInUse from "df.possible.combos"...

..... > library("sqldf") Loading required package: DBI Loading required package: gsubfn Loading required package: proto Loading required namespace: tcltk Loading Tcl/Tk interface ... done Loading required package: chron Loading required package: RSQLite Loading required package: RSQLite.extfuns > result<-sqldf("select data.*, meth450part.chromStart as MethChromStart, meth450part.chromEnd as MethChromEnd, meth450part.strand as MethStrand, meth450part.name as MethName, meth450part.score as MethScore from data join meth450part where data.V1=meth450part.chrom and data.V2<=m...

Dear all, I would like R to retrieve a table resulting from execute sql stored procedures. What function can I use? Can RODBC do it. I tried channel1 <- odbcConnect("ptsecmstqa01-alpha") query <- paste("execute DB.dbo.usp_test") Data<- sqlQuery(channel1, query) However, it returned blank. Best Regards, Suphajak Ngamlak Equity and Derivatives Trading Phatra

Hi, I post this message to the general r-help list hoping anyone within a wider range have suggestions: There are three ways to integration R and postgres, especially on 64bit Microsoft windows Platform, 1. via RODBC package, which has 32 bit and 64 bit version for windows 2. via RPostgres interface, which only has 32bit version currently 3. via plr for Greenplum, which only supports a

...emo()' for some demos, 'help()' for on-line help, or 'help.start()' for an HTML browser interface to help. Type 'q()' to quit R. > # Load the package > library(sqldf) Loading required package: DBI Loading required package: RSQLite Loading required package: RSQLite.extfuns Loading required package: gsubfn Loading required package: proto Loading required package: tcltk Loading Tcl/Tk interface ... done Loading required package: chron > > > # Use the titanic data set > > data(women) > colnames(women) [1] "height" "weight" > head...

...on rules to any R function, call or expression. * RSearchYJ (0.0.1) Yohei Sato http://crantastic.org/packages/RSearchYJ Search with Yahoo Japan * rseedcalc (1.0) Kevin Wright http://crantastic.org/packages/rseedcalc Estimate the percentage of seeds containing GM traits. * RSQLite.extfuns (0.0.1) Seth Falcon http://crantastic.org/packages/RSQLite-extfuns This package uses SQLite's loadable extension feature to provide a number of additional SQL functions and aggregates. The package is a wrapper of extension functions written by Liam Healy and made available through...