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 <macque...@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/
_______________________________________________
R-sig-DB mailing list -- R Special Interest Group
R-sig-DB@r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-db
