search for: dbexiststable

Displaying 9 results from an estimated 9 matches for "dbexiststable".

2012 Jun 12
1
Not able to write to PostgreSQL database using "dbWriteTable"
...rv1 <- dbDriver("PostgreSQL") i=6 connAE1 <- dbConnect(drv1,host = "xx.xxx.xxx.xxx", port = "6443", dbname="DB",user = "xxxxx",password = "xxx") as.data.frame(zz[1]) dbGetQuery(connAE1,'SELECT id FROM \"test1\"') if(dbExistsTable(connAE1, "test1")){ dbWriteTable(con=connAE1,name='test1.id',value=as.data.frame(i),row.names=T ,overwrite=F ,append=T) } dbDisconnect(connAE1) dbUnloadDriver(drv1) ++++++++++++++++++++++++++++++++++++++++++++++++++++++ Following is the past of the console Log for your Refere...
2003 Apr 24
1
RMySQL crash under R 1.7.0, but not 1.6.2
...n" and with a table "serie" under Win XP with R 1.6.2 using: > library(DBI) > library(RMySQL) Warning message: DLL attempted to change FPU control word from 8001f to 9001f > drv <- dbDriver("MySQL") > con <- dbConnect(drv, dbname="zooscan") > dbExistsTable(con, "serie") [1] TRUE > dbDisconnect(con) [1] TRUE Notice the warning message, but apparently without other incidence. Now, when I try this with R 1.7.0, R crashes at the line: > con <- dbConnect(drv, dbname="zooscan") with the error report containing: AppName: rgui...
2005 Oct 27
2
RSQLite problems
Hi, I'm experimenting with using (R)SQLite to do data management. Here are two little problems that I've encountered: 1. The presence of ',' in string values causes trouble since ',' is also the delimiter used in the SQL statement. 2. A newline '\n' line attached to the last string value of each row. Some examples: > library (RSQLite) Loading required
2006 Jan 05
1
Suggestion for big files [was: Re: A comment about R:]
...done <- TRUE > tt<-textConnection(tt) > if (i==1) { > assign("dat",read.table(tt,head=T,sep=",",quote="")); > } > else assign("dat",read.table(tt,head=F,sep=",",quote="")) > close(tt) > ifelse(dbExistsTable(con, "wvs"),dbWriteTable(con,"wvs",dat,append=T), > dbWriteTable(con,"wvs",dat) ) > } > close(f) > #end > It's not the best solution,but it works. > > > > > If you use 'scan', you could specify that you do not want > some...
2007 Mar 20
1
RMySQL load error
...1] "dbSendQuery" [1] "dbGetQuery" [1] "dbGetException" [1] "dbGetInfo" [1] "dbListResults" [1] "summary" [1] "dbListTables" [1] "dbReadTable" [1] "dbWriteTable" [1] "dbWriteTable" [1] "dbExistsTable" [1] "dbRemoveTable" [1] "dbListFields" [1] "dbCommit" [1] "dbRollback" [1] "dbCallProc" [1] "MySQLResult" [1] "dbClearResult" [1] "fetch" [1] "fetch" [1] "dbGetInfo" [1] "dbGetS...
2003 Nov 11
0
Installing and Loading RMySQL on OS X 2.8
...ct" [1] "dbDisconnect" [1] "dbSendQuery" [1] "dbGetQuery" [1] "dbGetException" [1] "dbGetInfo" [1] "dbListResults" [1] "summary" [1] "dbListTables" [1] "dbReadTable" [1] "dbWriteTable" [1] "dbExistsTable" [1] "dbRemoveTable" [1] "dbListFields" [1] "dbCommit" [1] "dbRollback" [1] "dbCallProc" [1] "MySQLResult" [1] "dbClearResult" [1] "fetch" [1] "fetch" [1] "dbGetInfo" [1] "dbGetStatement&qu...
2005 Mar 09
1
RMySQL installed but not availalable
...ot;dbSendQuery" > [1] "dbGetQuery" > [1] "dbGetException" > [1] "dbGetInfo" > [1] "dbListResults" > [1] "summary" > [1] "dbListTables" > [1] "dbReadTable" > [1] "dbWriteTable" > [1] "dbExistsTable" > [1] "dbRemoveTable" > [1] "dbListFields" > [1] "dbCommit" > [1] "dbRollback" > [1] "dbCallProc" > [1] "MySQLResult" > [1] "dbClearResult" > [1] "fetch" > [1] "fetch" > [1]...
2006 Jan 05
2
Suggestion for big files [was: Re: A comment about R:]
[ronggui] >R's week when handling large data file. I has a data file : 807 vars, >118519 obs.and its CVS format. Stata can read it in in 2 minus,but In >my PC,R almost can not handle. my pc's cpu 1.7G ;RAM 512M. Just (another) thought. I used to use SPSS, many, many years ago, on CDC machines, where the CPU had limited memory and no kind of paging architecture. Files did
2002 Oct 16
5
Database newbee problem...
Hi all, This is a potentially very stupid question about MySQL <-> R interaction, but I have not been able to solve it. I'm just trying to connect R to my MySQL databse, and gets this: > library(RMySQL) Loading required package: methods > m <- dbDriver("MySQL") > con <- dbConnect(m,group="testdb") Process R segmentation fault at Wed Oct 16 07:04:30