[R-sig-DB] Add a "dbSendUpdate" function to DBI?

[Hadley Wickham]

A thought: should dbSendUpdate() return a boolean indicating success,
or always return TRUE, otherwise throwing an error?

Hadley

On Wed, Sep 3, 2014 at 3:59 PM, MacQueen, Don <macqueen1 using llnl.gov> wrote:
> Hadley,
>
> Since you mentioned DBI 0.3 in a recent email, could I make a request to add
> a dbSendUpdate() function to DBI, like the one in RJDBC?
>
> require(RJDBC)
>
>> find('dbSendQuery')
> [1] "package:RJDBC" "package:DBI"
>
>> find('dbSendUpdate')
> [1] "package:RJDBC"
>
> And from ?dbSendUpdate
>
>   'dbSendQuery' and 'dbSendUpdate' submit a SQL query to the
>   database. The difference between the two is only that
>   'dbSendUpdate' is used with DBML queries and thus doesn't return
>   any result set.
>
> I would find this helpful, because I could then use scripts unmodified with
> either ROracle or RJDBC.
> (I suppose adding it to DBI would mean that the one in RJDBC would have to
> be modified.)
>
>
> I have:
>
> Package Version
>   "DBI" "0.3.0"
>
> Package Version
> "RJDBC" "0.2-4"
>
>
> Thanks
> -Don
>
> --
> Don MacQueen
> Lawrence Livermore National Laboratory
> 7000 East Ave., L-627
> Livermore, CA 94550
> 925-423-1062
>



-- 
http://had.co.nz/