Description Usage Arguments Value See Also Examples
Execute a prepared SQL statement on a database connection
1 2 3 | ## S4 method for signature 'JDBCConnection,character'
dbSendQuery(conn, statement,
parameters = list())
|
conn |
A |
statement |
A character vector of length one specifying the input to a prepared SQL statement. |
parameters |
A list of statement parameters, which will be inserted in order. |
A JDBCResult
object.
Depending on the query type a JDBCQueryResult
or a JDBCUpdateResult
.
Other JDBCConnection methods: dbConnect,JDBCConnection-method
,
dbDisconnect,JDBCConnection-method
,
dbj-edit-tables
,
dbj-sql-generate
,
dbj-sql-quote
, dbj-table
1 2 3 4 | ## Not run:
dbSendQuery(con, "UPDATE EMPLOYEES SET SALARY = ? WHERE ID = ?", list(3500, 624L))
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.