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

[Denis Mukhin]

I like it. dbExecuteQuery() matches well with already existing dbGetQuery() and dbSendQuery(). All three are essentially doing the same operation (submitting a Query) but have different return types.

Denis

-----Original Message-----
From: Hadley Wickham [mailto:hadley using rstudio.com] 
Sent: Thursday, September 04, 2014 10:54 AM
To: Denis Mukhin
Cc: MacQueen, Don; Simon Urbanek; r-sig-db using r-project.org
Subject: Re: [R-sig-DB] Add a "dbSendUpdate" function to DBI?

On Thu, Sep 4, 2014 at 9:28 AM, Denis Mukhin <denis.x.mukhin using oracle.com> wrote:
> In ROracle we standardized on the second approach, namely always return TRUE, otherwise throw an error.
>
> Also since UPDATE is not the only operation that does not return any results (although it might with a RETURNING clause) would a more generic name be more appropriate here? Besides DMLs there are also DDLs. Something like dbExecute(), dbSubmit(), dbSend() ...

How about dbExecuteQuery() ?

(dbSendQuery() is already taken.)

Hadley

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