Re: [R] pass vector binding to DBI parameter (rsqlite)

2014-08-12 Thread Jeff Newmiller
I am not quite sure what you are complaining about. The ODBC interface definition is not vectorized, and that has nothing to do with R... that applies across all platforms I have seen. The DBI API is consistent with that. There are some proprietary APIs that implement bulk data transfers, but th

Re: [R] pass vector binding to DBI parameter (rsqlite)

2014-08-12 Thread John McKown
On Tue, Aug 12, 2014 at 2:46 PM, Dan Muresan wrote: > Yes, of course, that's an obvious work-around, thanks. Another one is > to use temporary tables. > > But I'd like to know if binding a vector to an SQL parameter is > possible in rsqlite (or even in the DBI API or with other drivers -- > it se

Re: [R] pass vector binding to DBI parameter (rsqlite)

2014-08-12 Thread Dan Muresan
Yes, of course, that's an obvious work-around, thanks. Another one is to use temporary tables. But I'd like to know if binding a vector to an SQL parameter is possible in rsqlite (or even in the DBI API or with other drivers -- it seems to me it isn't). This seems like a nasty shortcoming (especia

Re: [R] pass vector binding to DBI parameter (rsqlite)

2014-08-12 Thread John McKown
On Tue, Aug 12, 2014 at 10:55 AM, Dan Muresan wrote: > Hi, is there a way to bind vectors to DBI query parameters? The > following tells me that vectors are sent as separate values: > >> library("RSQLite") >> c <- dbConnect (SQLite()) >> dbGetQuery(c, "create table tst (x int, y int)") >> dbGetQue

[R] pass vector binding to DBI parameter (rsqlite)

2014-08-12 Thread Dan Muresan
Hi, is there a way to bind vectors to DBI query parameters? The following tells me that vectors are sent as separate values: > library("RSQLite") > c <- dbConnect (SQLite()) > dbGetQuery(c, "create table tst (x int, y int)") > dbGetQuery(c, "insert into tst values (?, ?)", data.frame(x=c (1,2,1,2)