search for: dbclearresult

...xample from help (?dbHasCompleted ), Works ####### require("RSQLite") con <- dbConnect(RSQLite::SQLite(), ":memory:") dbWriteTable(con, "mtcars", mtcars) # Fetch all results res <- dbSendQuery(con, "SELECT * FROM mtcars WHERE cyl = 4") dbFetch(res) dbClearResult(res) # Fetch in chunks res <- dbSendQuery(con, "SELECT * FROM mtcars") dbHasCompleted(res) ## RETURNS FALSE !!! while (!dbHasCompleted(res)) { chunk <- fetch(res, 10) print(nrow(chunk)) } dbClearResult(res) dbDisconnect(con) ########## My Code, lamentably not reproduc...

...e below) has anybody found a solution? here is the code that gives me a segmentation fault library(Rdbi) library(Rdbi.PgSQL) conn <- dbConnect(PgSQL(), dbname = "PGA") tmp <- "create table test ( expid int, name varchar(128));" result <- dbSendQuery(conn,tmp) dbClearResult(result) the last line can be substituted by dbDisconnect(conn) and you get a segmentation fault too. The database PGA does exist and the dbSendQuery does create a table (i checked via psql) i followed the instructions given by tim (see url or msg below) and im sending (what think is) the back...

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

...fetch <- fetch(climate_query, n = db_fetch_n) print(climate_data_fetch[1,1] print(dbGetRowCount(climate_query)) # I want to do something with the climate_data_fetch "chunk" here, write out the results to a new table, and go to the next set of rows. } dbClearResult(climate_query) The first print statement shows the same thing over and over again, and the second print statement (dbGetRowCount) eventually exceeds the total number of rows in each of the tables. Is the issue that I'm selecting from multiple tables at once (they all have the same length)? I...

...e below) has anybody found a solution? here is the code that gives me a segmentation fault library(Rdbi) library(Rdbi.PgSQL) conn <- dbConnect(PgSQL(), dbname = "PGA") tmp <- "create table test ( expid int, name varchar(128));" result <- dbSendQuery(conn,tmp) dbClearResult(result) the last line can be substituted by dbDisconnect(conn) and you get a segmentation fault too. The database PGA does exist and the dbSendQuery does create a table (i checked via psql) i followed the instructions given by tim (see url or msg below) and im sending (what think is) the back...

...] "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] "dbGetStatement" [1] "dbListFields" [1] "dbColumnInfo" [1] "dbGetRowsAffected" [1] "dbGetRowCount" [1] "dbHasCompleted" [1] "dbGetException&quot...

...y" [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" [1] "dbListFields" [1] "dbColumnInfo" [1] "dbGetRowsAffected" [1] "dbGetRowCount" [1] "dbHasCompleted" [1] "dbGetException" [1] &quo...

...t;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" > [1] "dbListFields" > [1] "dbColumnInfo" > [1] "dbGetRowsAffected" > [1] "dbGetRowCount" > [1] "dbHasCompleted&...

Hello, Attached is a mail regarding question how to insert Date field using ROracle package. I am stuck with this problem and appreciate receiving help from gurus on this list. Code used mainly is: library(ROracle) ### --- Version 0.53 drv <- dbDriver("Oracle") con <- dbConnect( drv, "user/passwd") d <- data.frame(CDATE = "2004-03-10 10:12:00") ps

Dear List, Would anyone know how to perform prepared queries with ROBC ? I had a shot with some of the internal (non-exported) functions of the package but ended up with a segfault, so I prefer asking around before experimenting further... Thanks, Laurent

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

The subject of your email is missing. Perhaps you need to read the Posting Guide (again?) about attachments. Embedding your example directly in the body of the email is generally more accessible in archives than attaching it. -- Sent from my phone. Please excuse my brevity. On April 27, 2016 1:14:17 PM GMT+01:00, G.Maubach at gmx.de wrote: >Hi All, > >I am addressing this post to all

Hi All, I am addressing this post to all who are new to R. When learing R in the last weeks I took some notes for myself to have code snippets ready for the data analysis process. I put these snippets together as a script template for future use. Almost all of the given command prototypes are tested. The template script contains snippets for best practices and leaves out the commands that